question

eva0307-4932 avatar image
0 Votes"
eva0307-4932 asked eva0307-4932 answered

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

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}.

biztalk-server
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ColinDijkgraaf avatar image
0 Votes"
ColinDijkgraaf answered ColinDijkgraaf edited

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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

KamleshKumar avatar image
1 Vote"
KamleshKumar answered KamleshKumar commented

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

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello Kamlesh,

BizTalk details:
Version: 2016, TLS installed: 1.2

3rd party within same network db details:

Version: 2016, TLS installed: 1.2, yes SQL browser is running, ping and telnet working for both parties.

Do I need to modify the connection string for connecting to the TLS upgraded db?

0 Votes 0 ·

Dear user,

Thank you for all the details.

Please check if you are using any computer account certificate that has not expired on the SQL server.

Regards,
Kamlesh Kumar

0 Votes 0 ·
eva0307-4932 avatar image
0 Votes"
eva0307-4932 answered

thanks Colin, updating the provider in connection strng worked.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.