none
Regarding the SQL Server service starting problem

    Question

  • Hello all,

     

    This is my first time in questioning the MSDN forum.

    I had installed SQL Server on my comp and found that the service has not been started so i

    used the config manager to start the service but it throwed the following error in event viewer,

     SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

    and

     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.

    Kindly throw light on what might be wrong and what would be the solution for the same.

    Thanks in advance.

    Regards.

    Nirmal

    Friday, January 7, 2011 6:24 AM

Answers

  •  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.

     

     

    If you have enabled SSL certificate for SQL Service, then make sure the certificate is valid. If not then clear out the certificates from SQL server configuration manager and try starting the service.
    This error 0x80 can also occur when the SQL server service account doesn't have a local profile created in the system you are trying to start the service , look into Xiao's reply here http://social.msdn.microsoft.com/Forums/en/sqlexpress/thread/db68b3bf-33a8-42d6-8dac-f7229a2f9cde

     


    Thanks, Leks
    Friday, January 7, 2011 10:26 PM
    Answerer

All replies

  • Could you please post complete errorlog? I am suspecting more errors before this.
    ERRORLOG is generally located under C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG Folder



    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    Friday, January 7, 2011 7:03 AM
    Moderator
  • the above is the descrition part of the eror i found in the event viewer...

    Friday, January 7, 2011 7:24 AM
  • I know that. But as I mentioned, I want to see ERRORLOG content. I am suspecting more information about this error logged there.
    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    Friday, January 7, 2011 7:26 AM
    Moderator
  • This KB should solve your problem:
    http://support.microsoft.com/kb/928779
    Friday, January 7, 2011 1:09 PM
  •  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.

     

     

    If you have enabled SSL certificate for SQL Service, then make sure the certificate is valid. If not then clear out the certificates from SQL server configuration manager and try starting the service.
    This error 0x80 can also occur when the SQL server service account doesn't have a local profile created in the system you are trying to start the service , look into Xiao's reply here http://social.msdn.microsoft.com/Forums/en/sqlexpress/thread/db68b3bf-33a8-42d6-8dac-f7229a2f9cde

     


    Thanks, Leks
    Friday, January 7, 2011 10:26 PM
    Answerer