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.

Windows for business Windows Client for IT Pros User experience Other
SQL Server Other
{count} vote

Accepted answer
  1. Limitless Technology 44,746 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. Mongkhon Suwanbumrung 10 Reputation points
    2023-01-24T07:10:50.64+00:00

    Windows11 V22H2 cannot connect SQL server 2005 and i roll back to win11 v21H2 can connectUser's image


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.