Tuesday, February 1, 2011

SQL Server Configuration Manager - SQL Server Services - Exception

When I opened SQL Server 2008 R2 – SQL Server Configuration Manager, under "SQL Server Services" in the right hand pane had the following error "The server threw an exception. [0x80010105]"

Solution to this problem i found after doing research on internet:

Restart the "Windows Management Instrumentation" service on machine where SQL Configuration Manager is installed.

Start -> Run -> "Services.msc", scroll down to "Windows Management Instrumentation", right-click and "Restart"

Note: You may have to check with system administrator as there may be few other services dependent on this service and may be restarted as well.

Close and reopen SQL Server Configuration Manager and hopefully you'll see all SQL Server Services.

No comments: