After the Windows11 22H2 (kb5019980) update on the PC where SQL2008 Express server is installed, the connection does not work in Windows XP.

규헌 노 1 Reputation point
2022-11-14T06:13:11.047+00:00

After the Windows11 22H2 (kb5019980) update on the PC where SQL2008 Express server is installed, the connection does not work in Windows XP.

I wonder if there is a workaround for this part or if there is currently an error report.

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
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
8,873 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. YufeiShao-msft 7,081 Reputation points
    2022-11-15T06:57:56.877+00:00

    Hi @규헌 노 ,

    Windows11 does not support SQL 2008, you can check out this doc: Using SQL Server in Windows, and you also note that Microsoft has ended up the support for Win XP, there are also few SQL versions that Win XP can support
    Whether you can consider upgrading your SQL Server, the latest version of SQL Server is 2019, and also can consider upgrading to a new OS. XP itself in only capable of TLS 1.0, it cannot meet Win11
    260395-image.png

    You can try to telnet <your server>1433 from XP machine to see if you can get a connection, or check out your error log to see what errors are displayed


    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.