• Initializing the FallBack certificate failed . TDSSNIClient initialization failed


    安装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/

  • 相关阅读:
    关于svcutil.exe
    为什么说上ERP找死?
    竞争软件微信公众号上线
    无需ORM的数据库
    日期格式化和计算工具
    数据格式化工具
    Redis集群安装
    guava入门学习3(集合工具)
    guava入门学习2(新集合)
    mac环境下基于jdk1.8,maven搭建dubbo,zookeeper入门小案例
  • 原文地址:https://www.cnblogs.com/nzperfect/p/3621082.html
Copyright © 2020-2023  润新知