Forum Discussion

WillClarke's avatar
WillClarke
Occasional Contributor
6 years ago
Solved

SSL Security error when running SQL scripts

Hey all.   We made some security updates switching from TLS 1.1 to TLS 1.2 on our SQL servers and we get the following error when attempting to connect to the server "[DBNETLIB][ConnectionOpen ...
Scripting
  • WillClarke's avatar
    WillClarke
    6 years ago

    What the IT team ended up okaying and doing was adding a new ODBC DSN with stronger security. We updated the connection string to use the new DSN and it worked.

     

    Thanks for the suggestions and help.

tristaanogre's avatar
tristaanogre
Esteemed Contributor
6 years ago

I have not experience that issue.  However, when some of our servers and such switched here to use the new stronger certifications, some of our other software started generating errors.  Specifically, we were running the 2013 version of Team Explorer and that was generating a number of errors.

Turns out that it is a different in the .NET version.  Team Explorer 2017 uses a newer version of .NET which includes strong encryption as the default.  So, it COULD be possible that you need to make a registry key setting to change the .NET libraries for SQLOLDDB to use strong encryption.