DBA

SQL server could not start cannot find object or property (0x80092004)

Advertisements

SQL server could not start cannot find object or property (0x80092004)

Recently I got a call from my team the users couldn’t connect the SQL server and it’s throwing error. As always, I checked the SQL server status via configuration manager and noticed the server 2008 r2 stopped.  I tried to start the SQL server but it’s not started and its shows could not start the service. I went to the application log it has so many error messages.

Event viewer Errors:

 

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

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.

TDSSNIClient initialization failed with error 0x80092004, status code 0x1.

WMI Provider Error: Cannot find object or property (0x80092004)

initializing the fallback certificate failed with error code 1 state 1 error number -2146893802

 

I googled the errors and most of the posts and forum says it’s because of VIA protocol enabled. I looked the protocol it’s not enabled.

I tried to change the LOG ON services account from “Domain account” to “local system”, “Local service”, “Network service” and another domain account too. But nothing has worked.

Finally the problem solved by another method. And I thought to share this.

Run –> Control panel –> Administrative Tools –>Services

 

 

Leave the password blank –> click OK –> Restart the services. It worked for me. The same doesn’t work by configuration manager.

Hope this will help someone.

I’m currently working as a SQL server DBA in one of the top MNC. I’m passionate about SQL Server And I’m specialized in Administration and Performance tuning. I’m an active member of SQL server Central and MSDN forum. I also write articles in SQL server Central. For more Click here

Leave a Reply

Your email address will not be published. Required fields are marked *

29 + = 33