BizTalk Server General - BTS Deployment

Author

BTS Deployment - Binding Exception

Pitroda

2004-06-09, 8:31 am

Hi All

I am trying to use a binding file to deploy my SQL Adapter send/receive ports and I get the following errors in attempting to import the binding files:

"Failed updating binding information. BindingException: Could not validate TransportTypeData or Address properties for Primary Transport of Send Port 'Send_SQL'. Exception from HRESULT: 0x80131500"

I am using multiple computer configuration, where I have BizTalk installed in one machine, my SQL Server1 where BTS related DB's are installed is a Windows 2000 box and SQL Server2 where my application DB is installed, this machine is Windows 2003.
I have ensured that in my binding file for the passowrd field there are no "*". Still it is giving me the same error.

I changed to binding file to configure even pubs DB thinking that my DB is having problem. Yet it is giving me the same error.

Also, from my BizTalk Server machine, through ODBC, I am able to successfully create DSN connectivity.

Thanks in advance

Pitroda

2004-06-09, 11:00 am

All

Somewhere I read that I should give Enlist as false and try. But where will I give this?

I have Enable property set to False and also tried. Even it is not working fine.

Can anybody help me in this on how to fix this.

I made my user as a part of all user groups that hev been defined such as BizTalk
Application Users, SSO Administrators. Even then it is failing.

"Pitroda" wrote:

> Hi All
>
> I am trying to use a binding file to deploy my SQL Adapter send/receive ports and I get the following errors in attempting to import the binding files:
>
> "Failed updating binding information. BindingException: Could not validate TransportTypeData or Address properties for Primary Transport of Send Port 'Send_SQL'. Exception from HRESULT: 0x80131500"
>
> I am using multiple computer configuration, where I have BizTalk installed in one machine, my SQL Server1 where BTS related DB's are installed is a Windows 2000 box and SQL Server2 where my application DB is installed, this machine is Windows 2003.
> I have ensured that in my binding file for the passowrd field there are no "*". Still it is giving me the same error.
>
> I changed to binding file to configure even pubs DB thinking that my DB is having problem. Yet it is giving me the same error.
>
> Also, from my BizTalk Server machine, through ODBC, I am able to successfully create DSN connectivity.
>
> Thanks in advance
>

Mariusz Borsa [MSFT]

2004-06-10, 5:30 pm

Look for the connection string used by your SQL adapter in your binding
file, and ensure that this connection string is correct (e.g. has correct
username and password in case you're using SQL authentication) and that it
is pointing to SQL server which is up and running. If you're using Windows
authentication, make sure that the user invoking bindings import has the
proper access rights to SQL Server databases.

This posting is provided "AS IS" with no warranties, and confers no rights.

EBusiness Server Team
--------------------[vbcol=seagreen]
cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA0
1.phx.gbl!TK2MSFTNGXA03.phx.gbl[vbcol=seagreen]
will I give this?[vbcol=seagreen]
working fine.[vbcol=seagreen]
as BizTalk[vbcol=seagreen]
ports and I get the following errors in attempting to import the binding
files:[vbcol=seagreen]
validate TransportTypeData or Address properties for Primary Transport of
Send Port 'Send_SQL'. Exception from HRESULT: 0x80131500"[vbcol=seagreen]
installed in one machine, my SQL Server1 where BTS related DB's are
installed is a Windows 2000 box and SQL Server2 where my application DB is
installed, this machine is Windows 2003.[vbcol=seagreen]
no "*". Still it is giving me the same error.[vbcol=seagreen]
is having problem. Yet it is giving me the same error.[vbcol=seagreen]
successfully create DSN connectivity.[vbcol=seagreen]