I understand these are not officially supported, but I have seen people with these versions working just fine.
Windows Server 2012R2, everything works perfectly. Upgrading to Server 2016 and neither versions of SQL Server can login anymore – both get the same errors, so I’m guessing they are related.
Trying to login to the database engine in server management studio and get these errors on Windows authentication and SQL Server authentication.
From what I understand, a lot of things were changes in SQL 2012 and our databases are pretty old and unmaintained, but have been working perfectly, so I’d love to get ones of these versions to work.
SQL Server 2005 error:
TITLE: Connect to Server
Cannot connect to Testserver.
ADDITIONAL INFORMATION:
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 – The Local Security Authority cannot be contacted) (Microsoft SQL Server, Error: -2146893052)
Cannot connect to Testserver.
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 – The Local Security Authority cannot be contacted) (.Net SqlClient Data Provider)
SQL Server 2008 R2
TITLE: Connect to Server
Cannot connect to Testserver.
ADDITIONAL INFORMATION:
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 – The Local Security Authority cannot be contacted) (Microsoft SQL Server, Error: -2146893052)
Cannot connect to Testserver.
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 – The Local Security Authority cannot be contacted) (.Net SqlClient Data Provider)
I checked permissions for the user, enabled TLS 1.0 and 1.1 in case it was related to that. Installed a trial of SQL Server 2019 and that works, but only when encryption is disabled.
The references the errors give on the Microsoft site no longer exist.
veekay is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1