Cannot connect to SQL server 2005 on windows 2003 when I upgrade Windows 11 to 22H2

三 石 26 Reputation points

When I connect to sql server using SSMS, it show error "TITLE: 连接到服务器


无法连接到 XXXXX。



已成功与服务器建立连接,但是在登录过程中发生错误。 (provider: SSL Provider, error: 0 - 远程主机强迫关闭了一个现有的连接。) (Microsoft SQL Server, Error: 10054)

For help, click:








AND with other applications, it cannot work either.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,911 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
8,440 questions
{count} vote

Accepted answer
  1. Limitless Technology 44,011 Reputation points


    Thank you for your question and reaching out. I can understand you are having issues related to SQL connection from 2003 system.

    Please note that Windows 2003 is legacy OS and out of support , so it may not work with latest security protocols Like TLS ,SSL and SMB.


    --If the reply is helpful, please Upvote and Accept as answer--

5 additional answers

Sort by: Most helpful
  1. Bjoern Peters 8,856 Reputation points

    Windows Server 2003 and SQL Server 2005 are not able to use TLS 1.2 (which is used by default on W11), which is why you are not able to connect.

    There might be a chance to connect if you can configure your Windows 11 to use the old version.

    1 person found this answer helpful.
    0 comments No comments

  2. Mongkhon Suwanbumrung 10 Reputation points

    How To fix is working


    1 person found this answer helpful.
    0 comments No comments

  3. 三 石 26 Reputation points

    Thanks BjoernPeters, I hv enabled tls 1.0 & 1.1 via internet option, but still cannot work. btw it works on win11 previous version.

  4. CathyJi-MSFT 21,096 Reputation points Microsoft Vendor

    Hi @三 石 ,

    SQL server 2005 is out of supported for many years, suggest you upgrade your SQL server 2005 to a newer version. And SQL server 2005 is not supported for TLS 1.2. TLS 1.2 is supported for SQL server 2008 and newer version.

    Please disable TLS 1.2 and enable TLs 1.1 or 1.0 from registry key. Refer to this MS document to get detail steps. Or upgrade SQL server 2005 to a newer version.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    0 comments No comments