SQL Server Configuration Manager unable to connect error
While running SQL Server Configuration Manager on a Windows 2008 server I received an unable to connect error. The issue was an WMI corruption in the sqlmgmproviderxpsp2up.mof.
The issue was resolved by the following steps.
- In the start menu type “cmd“ (without quotes) and on the top search result, right click the program icon and choose Run as administrator
- Type “net stop winmgmt” (without quotes) and press Enter to make certain the WindowsManagementInstrumentation (WMI) service is not running. If it is restarting set it to disabled and stop the service.
- Open a Windows Explorer and locate the path to C:\ windows\system32\WBEM\ folder and rename the Repository folder to something else like RepositoryOLD (right click and choose ‘Rename Folder‘). Set the service back to automatic.
- Reboot and restart as normal.
- In the start menu type “cmd“ (without quotes) and on the top search result, right click the icon and choose Run as administrator
- Type “net stop winmgmt” (without quotes) and press enter to stop the WMI service. If it is restarting set it to manual and stop the service.
- Type “winmgmt /resetRepository” (without quotes) and restart the computer.
Right click on command prompt and select Run as Administrator and type mofcomp.exe “C:\Program Files (x86)\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof”
Leave a Reply