IT Blog

In this blog we are showing if you are getting error while getting error the server is unreachable how to resolve the issue.

Issue–
1. On a 64-bit system, you install an instance of the 32-bit version of Microsoft SQL Server. On the same system, you install an instance of the 64-bit version of SQL Server 2008. If you then uninstall the 64-bit instance, you receive the below error.

Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager.

2. This problem occurs if users uninstall the 32-bit instance, and you then open SQL Server Configuration Manager.

Cause–
WMI provider is removed when you uninstall an instance of SQL Server.
32-bit instance and 64-bit instance of SQL Server share the same WMI configuration file. This file is located in the %programfiles(x86)% folder.

Solution–

1.  Verify the Sqlmgmproviderxpsp2up.mof file is present in %programfiles(x86)%\Microsoft SQL Server\number\Shared folder.

2. Open the command prompt and type the below command.
mofcomp “%programfiles(x86)% \Microsoft SQL Server\number \Shared\sqlmgmproviderxpsp2up.mof”

Note – use 80, 90, 100, 105, 105, 110, 120, 130 at the place of number in command.

3.  Go to the Services > select the Windows Management Instrumentation and restart the service.

4. Now go and launch SQL Server Manager without any error.