Wednesday, April 7, 2010

Unable to start SQL service SSL encryption fails

I did get some lovely errors in the SQL server log when try to start the service

Unable to initialize SSL encryption
because a valid certificate could not be found, and it is not possible to
create a self-signed certificate.
TDSSNIClient initialization failed with error 0x80092004, status code 0x80.
TDSSNIClient initialization failed with error 0x80092004, status code 0x1.v
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

My environment was a two node cluster with windows 2008 and SQL 2008, SP1, CLU4. The error just appears on one of the nodes. On the first one SQL start as it shall do.
After a lot of digging I find a solution on the error. I just changed the account running SQL server. My theory is that the account has too many characters in the name. I have no true proof for this but I have seen some other stupid errors when using account over 16 characters. For example I have not been able to change the password or when add a node to a cluster it will not take the password even if I know I type the correct one. Anyone else who has experience about this? Please let me know.

No comments: