SQL server could not start cannot find object or property (0×80092004)
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 0×80092004, status code 0×1.
WMI Provider Error: Cannot find object or property (0×80092004)
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.