BizTalk 2004 message when binding SQL Server ports

Home Page Forums BizTalk 2004 – BizTalk 2010 BizTalk 2004 message when binding SQL Server ports

Viewing 1 reply thread
  • Author
    Posts
    • #19432

      We are running BT 2004 SP2 on a Windows 2003 server. Our application databases, which we are trying to bind, are on a SQL Server 2005 box and our BizTalk databases are running on a SQL Server 2000 instance. When we run our binding we get the following:

      BindingException: Could not validate TransportTypeData or Address properties for Primary Transport of Send Port

       Has anyone ever seen that and know what to do to fix it? We are desperate.

       

      Thanks!!!

      Jessica

    • #19486

      From the top of my head, things to check in this scenario are:

      The sql server details and the sql connection string that are being applied in the bindings.

      You should also check that the MSDTC settings are set up correctly on the BizTalk server (Admin Tools/Component Services) – expand until you see My Computer under Component Services, right click/properties.  MSDTC tab.  Security Configuration button – we usually have the following selected:

      Network DTC Access, Allow Remote Clients, Allow Remote Admin, Allow Inbound, Allow Outbound, No Authentication Required, Enable TIP Transactions, Enable XA Transactions.

      I have seen it in the past where applying a patch or service pack can set the No Authentication Required radio back to Mutual Authentication Required which can then cause BizTalk problems with bindings (and also with deployment I think).

      Cheers

      Stu.

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.