How to prepare for updating SQL Server 2014 SP1 to SP3?

William Vincent 20 Reputation points
2024-11-12T19:09:19.09+00:00

I cannot create a SQL connection from Windows Server 2019 to Windows Server 2012 without throwing SQL Server Error: 772, SSL Security error. I can telnet successfully from the new to the old. I also have an established, working connection from old to new. My goal is to also create a Linked Server connection from new to old just like I have from old to new. Is my issue TLS related due to having SQL Server 2014 SP1 running on the old? If so, what should I expect if I install SP3? How should I prepare?

Microsoft Q&A
Microsoft Q&A
Use this tag to share suggestions, feature requests, and bugs with the Microsoft Q&A team. The Microsoft Q&A team will evaluate your feedback on a regular basis and provide updates along the way.
830 questions
0 comments No comments
{count} votes

Accepted answer
  1. S.Sengupta 20,636 Reputation points MVP
    2024-11-13T11:17:38.13+00:00

    Error 772 typically indicates a TLS/SSL negotiation failure, and you're right to suspect it's related to TLS versions, especially given the different SQL Server versions involved.

    After installing SP3, enabling TLS 1.2, and rebooting, the SQL connection between Windows Server 2019 and Windows Server 2012 should no longer throw SSL errors

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful

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.