Forum Discussion

WillClarke's avatar
WillClarke
Occasional Contributor
7 years ago

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

jab4743's avatar
jab4743
Contributor

Not exactly a match to your isssue but I encountered this TSL issue in Visual Studio.  Microsoft recommended forcing the underlying System.Net ServicePointManager to negotiate downlevel SSL instead of using TLS.  They provided a plugin for VS that worked.  You will need to research if this is possible in TC.

tristaanogre's avatar
tristaanogre
Esteemed Contributor
7 years ago

Again, it's a .NET version registry key

 

Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\.NETFramework\v4.0.30319

 

if it's not present, create a DWORD key called SchUseStrongCrypto and set it to 1.  Do it for oth the WOW6432 and the Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETFramework\v4.0.30319