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

Eva Baishya 61 Reputation points
2021-02-25T11:31:44.857+00:00

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

Microsoft BizTalk Server
Microsoft BizTalk Server
A family of Microsoft server products that support large-scale implementation management of enterprise application integration processes.
365 questions
0 comments No comments
{count} votes

Accepted answer
  1. Colin Dijkgraaf 1,361 Reputation points
    2021-03-18T19:50:34.407+00:00

    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.

    0 comments No comments

2 additional answers

Sort by: Most helpful
  1. Kamlesh Kumar 3,861 Reputation points
    2021-02-25T17:26:52.057+00:00

    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

    1 person found this answer helpful.

  2. Eva Baishya 61 Reputation points
    2021-04-06T05:28:22.25+00:00

    thanks Colin, updating the provider in connection strng worked.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.