在将Windows升级为Windows Pro 10 21H2后,我遇到了同样的问题。我有两个SQL实例 - 2014和2019,但我无法连接到2019版本。
我重启了计算机并重启了所有与SQL相关的服务。其中两个服务显示错误(SQL Server和SQL Server代理),我无法启动它们。
我也无法从C:\ Windows \ SysWOW64 \ SQLServerManager15.msc启动这两个服务。
在日志文件中(C:\ Program Files \ Microsoft SQL Server \ MSSQL15.MSSQLSERVER01 \ MSSQL \ Log)我看到了以下内容:
Initializing the FallBack certificate failed with error code: 15, state: 29, error number: 0.
Error: 17190, Severity: 16, State: 1.
Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate.
Error: 17182, Severity: 16, State: 1.
TDSSNIClient initialization failed with error 0x80092004, status code 0x80. Reason: Unable to initialize SSL support. Cannot find object or property.
Error: 17182, Severity: 16, State: 1.
TDSSNIClient initialization failed with error 0x80092004, status code 0x1. Reason: Initialization failed with an infrastructure error. Check for previous errors. Cannot find object or property.
Error: 17826, Severity: 18, State: 3.
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.
Error: 17120, Severity: 16, State: 1.
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.
原来在升级后,服务的“登录”属性(服务属性的第二个选项卡)被设置为NT AUTHORITY\NETWORK SERVICES。当我将其更改为“本地系统帐户”时,我能够启动该服务并连接到MS SQL 2019实例。
这篇msdn论坛帖子帮助我找到了这个解决方法。