暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

Initializing the FallBack certificate failed

原创 沙沃兴 2023-02-10
734

问题:

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

检查数据库的错误日志信息如下:

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

Service does not start | TDSSNIClient initialization failed with error 0x80092004, status code 0x80 | SQL Server DBA Diaries (sqldbadiaries.com)

「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论