Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server unable to start with error "Initializing the FallBack certificate failed with error code: 1, state: 1, error number: -2146893788" Expand / Collapse
Author
Message
Posted Monday, March 25, 2013 3:54 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, November 7, 2014 2:15 AM
Points: 206, Visits: 330
Hi Everyone,

We have a two node active/passive SQL cluster. Below is the OS version and SQL Version:
OS: Windows Server 2008 R2 SP1 Enterprise Edition
SQL Version: Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64)

On node A, everything is working fine. When we try to failover from Node A to node B, all the resources are coming online on node B except SQL Server. SQL Service is failing to come online. And we can see below errors sequentially:
- Initializing the FallBack certificate failed with error code: 1, state: 1, error number: -2146893788.
- TDSSNIClient initialization failed with error 0x80092004, status code 0x80. Reason: Unable to initialize SSL support. Cannot find object or property.
- 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.
- 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.
- SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
- [sqsrvres] StartResourceService: Failed to start MSSQLSERVER service. CurrentState: 1


Any feedback will be much appreciated.
Post #1434798
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse