问题:
用户反馈重启数据库服务器的备节点后,数据库服务无法启动,提示下面的错误。

检查数据库的错误日志信息如下:
2014-03-24 14:33:10.06 spid13s Error: 17190, Severity: 16, State: 1.
2014-03-24 14:33:10.06 spid13s Initializing the FallBack certificate failed with error code: 1, state: 20, error number: 0.
2014-03-24 14:33:10.06 spid13s Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate.
2014-03-24 14:33:10.06 spid13s Error: 17182, Severity: 16, State: 1.
2014-03-24 14:33:10.06 spid13s TDSSNIClient initialization failed with error 0x80092004, status code 0x80. Reason: Unable to initialize SSL support. Cannot find object or property.
2014-03-24 14:33:10.06 spid13s Error: 17182, Severity: 16, State: 1.
2014-03-24 14:33:10.06 spid13s 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.
2014-03-24 14:33:10.06 spid13s Error: 17826, Severity: 18, State: 3.
2014-03-24 14:33:10.06 spid13s 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.
2014-03-24 14:33:10.06 spid13s Error: 17120, Severity: 16, State: 1.
2014-03-24 14:33:10.06 spid13s SQL Server could not spawn FRunCommunicationsManager thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
原因分析:
因为数据库搭建了always on高可用性组,所以数据库服务启动账号是使用域账号来管理的。尝试使用本地账号启动数据库服务,发现可以正常启动。
经查原因:
SQL启动域帐号的status=Temporary
Windows Server 2012位置:Control Panel --> system --> Advanced system settings --> Advanced --> User Profiles -->Settings
可以看到SQL Server服务的启动账号有两个Profiles文件,一个状态是Backup,一个是Temporary。正常情况应该是只有一个状态为local的文件。

正常情况应该是

解决方案:
方案一:
删除状态是Backup的profile文件,然后重新启动。
方案二:
1.SQL启动帐号改成local system.
2.退域重加域
之后再查启动帐号的status=Local
本次是使用方案一进行处理的,删除文件后重新登录操作系统跟刚加域后登录很相似。
启动服务时错误 17182 SQL Server错误 - SQL Server | Microsoft Docs
Initializing the FallBack certificate failed . TDSSNIClient initialization failed-布布扣-bubuko.com




