Installing SSMS to work with SQL 2005 Server on Windows 11

If you cannot get SSMS to work with SQL 2005 server from Windows 11 workstations, then you need to do the following:

 Run gpedit.msc, and then press Enter.

 Go to Computer Configuration > Administrative Templates > Network > SSL Configuration Settings.

 Under SSL Configuration Settings, select SSL Cipher Suite Order

 Enable the policy.

 You will see a long string appear in the empty window below enable.  Scroll to the end of that string and add the string below to the end of it.  Apply the settings and reboot.  You will now be able to connect to SQL 2005/2008 if you are running Server 2003/2008R1.

  _TLS_DHE_RSA_WITH_AES_256_GCM_SHA384,TLS_DHE_RSA_WITH_AES_128_GCM_SHA256,TLS_RSA_WITH_3DES_EDE_CBC_SHA