I have updated my PC to Windows 11 Pro ver 22H2, Os build 22621.1 After this update, I cannot connect to SQL Server 2005 from SSMS v.18.4
Client OS: Windows 11 Pro ver 22H2, Os build 22621.1
Client SSMS: SSMS v.18.4
Server OS: Windows 2003 5.2.3790 Service Pack 2 Build 3790
SQL Server: SQL Server 2005
I have gone thru many web links and came to know it is some thing related to TLS protocol. As we cannot change the protocol, I tried changing this on the client PC ( where the SSMS v18.4 is running). As suggested by Microsoft, I used NARTAC's IIS Crypto 3.3 to set the TLS to 1.0.
But still I'm getting the error.
A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - An existing connection was forcibly closed by the remote host.) (Microsoft SQL Server, Error: 10054)
An existing connection was forcibly closed by the remote host