Score:0

Cannot start SQL Server 2022 on a system with TLS 1.3 only

kr flag

From documentation it seems that SQL Server 2022 should support TLS 1.3:

SQL Server 2022 (16.x) supports Transport Layer Security (TLS) 1.3 when TDS 8.0 is used. link

However, when I try to start a service on Windows Server 2022, where only TLS 1.3 is enabled (I have disabled TLS 1.2 and older protocols), the server will not start. I see the following errors in event log:

SQL Server could not spawn FRunCommunicationsManager thread. Check the SQL Server error log and the operating system error log for information about possible related problems.
Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
TDSSNIClient initialization failed with error 0x139f, status code 0x1. Reason: Initialization failed with an infrastructure error. Check for previous errors. The group or resource is not in the correct state to perform the requested operation. 
TDSSNIClient initialization failed with error 0x139f, status code 0x80. Reason: Unable to initialize SSL support. The group or resource is not in the correct state to perform the requested operation. 
The server was unable to initialize encryption because of a problem with a security library. The security library may be missing. Verify that security.dll exists on the system.

In earlier versions of Windows Server there was a similar problem with TLS 1.2 which was fixed with a patch. Is there anything similar for SQL Server 2022 and TLS 1.3? Or should TLS 1.2 be enabled anyway.

I sit in a Tesla and translated this thread with Ai:

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.