惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

Martin Fowler
Martin Fowler
大猫的无限游戏
大猫的无限游戏
J
Java Code Geeks
罗磊的独立博客
雷峰网
雷峰网
G
Google Developers Blog
Cyber Security Advisories - MS-ISAC
Cyber Security Advisories - MS-ISAC
爱范儿
爱范儿
B
Blog RSS Feed
腾讯CDC
Apple Machine Learning Research
Apple Machine Learning Research
D
Docker
Recent Announcements
Recent Announcements
T
Tailwind CSS Blog
博客园 - 聂微东
让小产品的独立变现更简单 - ezindie.com
让小产品的独立变现更简单 - ezindie.com
Vercel News
Vercel News
小众软件
小众软件
人人都是产品经理
人人都是产品经理
云风的 BLOG
云风的 BLOG
IT之家
IT之家
Blog — PlanetScale
Blog — PlanetScale
I
InfoQ
S
SegmentFault 最新的问题

博客园 - nzperfect

PAGELATCH_EX Contention on 2:1:103 SQL Server AlwaysON 同步模式的疑似陷阱 XEvent – SQL Server Log文件对磁盘的写操作大小是多少 SQL Server Log文件对磁盘的写操作大小是多少 Error after SQL Server 2012 installation: Login Failure for "SQL Server Integration Services 11.0" SSIS service SQL Server 灾难恢复31天之第6天:管理区分配页损坏处理 SQL Server 灾难恢复31天之第5天:处理损坏的非聚集索引 SQL Server 灾难恢复31天之第3天:在还原数据库时确定需要哪些备份文件 SQL Server 灾难恢复31天之第4天:备份 SQL Server 灾难恢复31天之第2天:包含数据库备份在还原时的保护 SQL Server 灾难恢复31天之第1天:DBCC CHECK命令会自动使用已经存在的数据库快照吗? 发布订阅延迟故障排查案例:分发读进程延迟 Query Hint FAST number_rows 改变SQL Server 执行计划 SQL Server 通过界面生成修改列类型脚本时的一个风险(或Bug) 是什么引起执行计划变得极其糟糕? 应该使用更新统计信息来解决它吗? 如何完整的修改一个数据库的名称 update值与原值相同时,SQL Server会真的去update还是忽略呢? How can I bring mirror database online after principal server is down ? performance monitor没有SQL Server性能计数器
Initializing the FallBack certificate failed . TDSSNIClie...
nzperfect · 2014-03-24 · via 博客园 - nzperfect

安装SQL后服务不能启动,报错:

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.

经查原因:

SQL启动域帐号的status=Temporary

Windows Server 2012位置:Control Panel --> system --> Advanced system settings --> Advanced --> User Profiles -->Settings

解决方法:

1.SQL启动帐号改成local system.

2.退域重加域

之后再查启动帐号的status=Local

参考:http://www.sqldbadiaries.com/2013/01/01/service-does-not-start-tdssniclient-initialization-failed-with-error-0x80092004-status-code-0x80/