sql server 2012 開啟sql server configuration manager 報錯

標籤：permission   message   blank   server   manager   

Error message when you open SQL Server Configuration Manager in SQL Server: "Cannot connect to WMI provider. You do not have permission or the server is unreachable"

650) this.width=650;" title="2017-03-20_115520" style="border-top: 0px; border-right: 0px; background-image: none; border-bottom: 0px; padding-top: 0px; padding-left: 0px; border-left: 0px; padding-right: 0px" border="0" alt="2017-03-20_115520" src="http://s3.51cto.com/wyfs02/M02/8E/ED/wKioL1jPYMHy2CaaAACJLnJ3PxY966.jpg" "562" height="255" />

 

 

Workaround解決辦法

To work around this problem, open a command prompt, type the following command, and then press ENTER:

mofcomp "%programfiles(x86)%\Microsoft SQL Server\number\Shared\sqlmgmproviderxpsp2up.mof"

Note For this command to succeed, the Sqlmgmproviderxpsp2up.mof file must be present in the %programfiles(x86)%\Microsoft SQL Server\number\Shared folder.
The value of number depends on the version of SQL Server:nnn

Microsoft SQL Server 2012                                110

Microsoft SQL Server 2008 R2                              100

Microsoft SQL Server 2008                              100

Microsoft SQL Server 2005                              90

After you run the Mofcomp tool, restart the WMI service for the changes to take effect. The service name is Windows management Instrumentation.

 

微軟官方地址：https://support.microsoft.com/en-us/help/956013/error-message-when-you-open-sql-server-configuration-manager-in-sql-server-cannot-connect-to-wmi-provider.-you-do-not-have-permission-or-the-server-is-unreachable

sql server 2012 開啟sql server configuration manager 報錯