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

三 石 26 Reputation points
2022-09-28T08:32:26.317+00:00

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

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

无法连接到 XXXXX。

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

ADDITIONAL INFORMATION:

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

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=10054&LinkId=20476

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

远程主机强迫关闭了一个现有的连接。

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

BUTTONS:

OK

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

"

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
    2022-09-30T07:51:18.643+00:00

    Hello

    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
    2022-09-28T09:11:02.97+00:00

    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
    2023-01-25T04:22:41.4566667+00:00

    How To fix is working

    [https://learn.microsoft.com/en-us/answers/questions/1095561/windows-11-22h2-update-breaking-connections-to-leg?page=1&orderby=Helpful&comment=answer-1100363#newest-answer-comment

    1 person found this answer helpful.
    0 comments No comments

  3. 三 石 26 Reputation points
    2022-09-28T22:59:08.587+00:00

    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
    2022-09-29T06:52:16.07+00:00

    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