SQL 2005 Cluster install issue

[kodaksmile]

Hi,

I have run into an odd SQL 2005 sp2 cluster install issue. I did the install of standard edition, applied the sp2 and when I go to fail over the instance (currently running on one node) it fails with:

The resource database build version is 9.00.3042. This is an informational message only. No user action is required.
2009-11-18 08:47:59.69 spid5s Error: 15466, Severity: 16, State: 1.
2009-11-18 08:47:59.69 spid5s An error occurred during decryption.
2009-11-18 08:47:59.70 spid5s Server name is 'WSQL115S'. This is an informational message only. No user action is required.
2009-11-18 08:47:59.70 spid9s Starting up database 'model'.
2009-11-18 08:47:59.70 spid5s The NETBIOS name of the local node that is running the server is 'WCLN127S'. This is an informational message only. No user action is required.
2009-11-18 08:47:59.70 Server Error: 17190, Severity: 16, State: 1.
2009-11-18 08:47:59.70 Server FallBack certificate initialization failed with error code: 1.
2009-11-18 08:47:59.70 Server Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate.
2009-11-18 08:47:59.70 Server Error: 17182, Severity: 16, State: 1.
2009-11-18 08:47:59.70 Server TDSSNIClient initialization failed with error 0x80092004, status code 0x80.
2009-11-18 08:47:59.70 Server Error: 17182, Severity: 16, State: 1.
2009-11-18 08:47:59.70 Server TDSSNIClient initialization failed with error 0x80092004, status code 0x1.
2009-11-18 08:47:59.70 Server Error: 17826, Severity: 18, State: 3.
2009-11-18 08:47:59.70 Server 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.
2009-11-18 08:47:59.70 Server Error: 17120, Severity: 16, State: 1.
2009-11-18 08:47:59.70 Server SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

I checked in sql configuration manager and there are no certificates configured...

Any suggestions?

 

[kodaksmile]

Just in case anyone else ever runs into this the issue was a corrupted profile on the node sql could not start up on. Certificates are used when sql is starting up even when you do not have SSL configured. SQL creates a self-generated certificate if a Certificate is not explicitly specified and/or is not installed. This information is saved in the profile for the SQL Server service account. If the profile has not been created then SQL cannot register the self-generated certificate