An error occurred in SQL Server login

Question

An error occurred in SQL Server login

pooo zz 100

Hello experts,

I am using sql2003 link sql2016 error reported, preliminary suspicion is a TCP problem.

please give me some advice.

User's image

Answer 1

CosmogHong-MSFT 14,591 Microsoft Vendor

Hi @pooo zz

Please troubleshoot follow by this doc: An existing connection was forcibly closed by the remote host (OS error 10054).

Best regards,

Cosmog Hong

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.

pooo zz 100 Reputation points

2023-03-21T05:16:25.4633333+00:00

can you give me some advice, it's really urgent, I have an idea to do the database migration to the new machine, but I'm not sure if it will work.
pooo zz 100 Reputation points

2023-03-21T05:16:54.02+00:00

Thank you for your reply. I have seen this document and tried it, but this has not solved my problem. Our server uses Windows Server 2003, and the database version is SQL Server 2008R2. I have suspected whether the problem is caused by the low version of TLS. When I opened the linked SQL server, I checked that the port number and instance name, including TLS, have not disabled the lower version of 1.0. Do you have any other suggestions.
CosmogHong-MSFT 14,591 Reputation points Microsoft Vendor

2023-03-21T07:40:37.7933333+00:00

Hi @pooo zz

Found in this thread that it might because you didn't meet password validation requirements. Make sure your password is at least 8 characters and contains a number and a special character.
pooo zz 100 Reputation points

2023-03-21T08:17:32.0233333+00:00

I have checked that the password length is consistent, and the properties have also checked whether the login account has opened the remote link, whether because my server version is too low to do some existing test methods on the Internet, I used UDL test, but I can't connect to show SSL error.
CosmogHong-MSFT 14,591 Reputation points Microsoft Vendor

2023-03-24T06:56:44.1966667+00:00

Sorry but SQL server 2003 is a product that is too old to support. I could hardly provide more support. :(
pooo zz 100 Reputation points

2023-03-27T05:10:38.9466667+00:00

Thank you, the result of the discussion is that we will upgrade the original server.

An error occurred in SQL Server login

0 additional answers

Activity