Wednesday, August 6, 2014

Cannot connect to WMI provider. You do not have permission or the server is unreachable in SQL Server 2012

After installing SQL Server 2012, I installed other MS software as well. However, when I restart my pc and log in to SQL, I encountered an error as seen in this image.

Specifications:

Windows 7 Enterprise 64 Bit
Software: SQL Server 2012 64 Bit (Enterprise or Developer) editions

Solution:
1. Right click command prompt and select "Run as Administrator"
2. Type the following in the command prompt C:\
mofcomp "%programfiles(x86)%\Microsoft SQL Server\110\Shared\sqlmgmproviderxpsp2up.mof"
(where 110 is the unique instance id for SQL Server 2012)

Note For this command to succeed, the Sqlmgmproviderxpsp2up.mof file must be present in the
%programfiles(x86)%\Microsoft SQL Server\number\Shared folder.

Reference: Cannot connect to WMI provider

0 comments:

Post a Comment