3rd party MSSQL server TLS SQL upgrade, BizTalk cannot connect via connection string

Question

A 3rd party MSSQL server had a TLS upgrade recently in the MSSQL database server, since then BizTalk cannot connect via connection string, error : [DBNETLIB][ConnectionOpen (Connect()).]Specified SQL server not found.. what changes need to be done to the connection string to be able to connect to the SQL server after TLS upgrade? Current db connection string: Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog={db name};Data Source={dbserver name}.

Answer 1

You need to install SQL Server 2012 Native Client version 11 and update the connection string and change the Provider from SQLOLEDB.1 to SQLNCLI11 as SQLOLEDB.1 doesn't support TLS 1.2

See Support for TLS 1.2 protocol in BizTalk Server.

As per KamleshKumar answer we would need to know the version of BizTalk and what CU level is installed to give a more precise answer.

Answer 2

Dear member,

Thank you for posting your question on the Microsoft Q&A platform.

We would need some more information like which version of BizTalk you are using and Is TLS installed at the destination server only? Which version of SQL installed there? Also, check the compatibilities with your BizTalk version.

You can check the below steps for further troubleshooting,

1. Is SQL Browser running?
2. Ping & Telnet is working between both the parties?

Regards,
Kamlesh Kumar

Answer 3

thanks Colin, updating the provider in connection strng worked.