Search code examples
sql-serverwindowsdesktop-application

Windows 10 Update 2004 breaks SQL connection


I have a few clients which are having issue with direct SQL connections after updating windows to the latest feature update 2004!

Basically the systems are able to open a telnet session fine on the 1433 so I am confident that its not a lower layer issue but applications like SSMS can't connect out!

I have even updated to KB4571744 to see if that helps but no..

My test system which I am using for diagnostics is running build 19041.488

My first set of tests have been trying to disable/override all the new security stuff but without any success.

Anyone seen this or know further diagnostic/fixes I could try? Thanks, Richard.


Solution

  • Fixed! the issue was that the new 2004 update stops TLS below 1.2, understandably! The server we are connecting to happened to be a little old! Updated the server and all works fine! :)