SSMS stopped connecting to the server

Antony 1 Reputation point
2022-11-16T23:22:46.797+00:00

I've just installed the latest Windows 11 update and SSMS has stopped connecting to SQLEXPRESS Server 2005 with error

TITLE: Connect to Server

------------------------------

Cannot connect to ..*.10\SQLEXPRESS, 1049.

------------------------------

ADDITIONAL INFORMATION:
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)
For help, click: https://learn.microsoft.com/sql/relational-databases/errors-events/mssqlserver-10054-database-engine-error

------------------------------

An existing connection was forcibly closed by the remote host

------------------------------

BUTTONS:
OK

------------------------------

If i follow the abouve ling it shows "404 - Page not found"

NOT updated systems are still able to connect without any issues. How can I fix this problem?

Versions:
SQL Server Management Studio 15.0.18424.0
SQL Server Management Objects (SMO) 16.100.47021.0+7eef34a564af48c5b0cf0d617a65fd77f06c3eb1
Microsoft Analysis Services Client Tools 15.0.19750.0
Microsoft Data Access Components (MDAC) 10.0.22621.819
Microsoft MSXML 3.0 6.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 10.0.22621

Windows specification:
Edition Windows 11 Pro
Version 22H2
Installed on ‎10/‎11/‎2022
OS build 22621.819

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,265 questions
{count} votes

7 answers

Sort by: Most helpful
  1. Maire Olivier 16 Reputation points
    2023-08-25T03:57:25.8+00:00

    Got the same issue on a Windows 11 computer trying to connect to an old SQL 2005 DB.
    It looks like some ciphers are disabled on Windows 11 and prevent the connection with the Database.

    In Powershell (as admin) after running the following command, I could connect to the DB.
    Hope this helps.

    Enable-TlsCipherSuite -Name "TLS_RSA_WITH_3DES_EDE_CBC_SHA"
    
    2 people found this answer helpful.
    0 comments No comments

  2. Seeya Xi-MSFT 16,461 Reputation points
    2022-11-17T02:12:19.12+00:00

    Hi @Antony ,

    SQL Server Management Studio 15.0.18424.0

    You can try to install the latest GA version: SSMS 18.12.1
    Use different authentication methods to troubleshoot. sqlcmd can help you troubleshoot if SSMS has a problem.
    In addition, please check the errorlog of SQL Server. If you see errors related to misaligned sector IOs, please refer to this thread:
    SQL Server not connected after windows 11 update

    Best regards,
    Seeya


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

  3. Antony 1 Reputation point
    2022-11-17T09:35:14.26+00:00

    Hi @Seeya Xi-MSFT ,

    Thank you for the reply. Both v8.12.1 and v19.0 Preview 3 show the same error. Connection is established, but then remote side breaks it.

    261320-sql-error.png


  4. Jingyang Li 5,891 Reputation points
    2022-11-17T21:21:42.36+00:00

    SQLEXPRESS Server 2005 is very old.
    Don't know how to reproduce the issue you are running into today.

    By the way, SQL Server 2022 was released yesterday.

    0 comments No comments

  5. Antony 1 Reputation point
    2022-11-20T23:52:32.67+00:00

    Any more options to fix SSL related problem?

    0 comments No comments