當你試圖打開SQL Server Configuation Manager時發現如下錯誤:
“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.” Invalid class [0x8004100]
不要驚慌,這是因為你的SQL實例的WMI provider被意外移除了。不管是32位的SQL實例還是64位有SQL實例都引用相同的WMI設置(這個設置在:“%programfile(x86)%/Microsoft SQL Server/[version]/Shared/sqlmgmproviderxpsp2up.mof”)
所以只要進入“%programfile(x86)%/Microsoft SQL Server/[version]/Shared目錄,然后執行
mofcomp sqlmgmproviderxpsp2up.mofView Code
然后重啟SQL Server Configuration Manager就可以了。
[version]與SQL Server對應關系如下:SQL Server 版本 | [Version]----------------------------------|----------Microsoft SQL Server 2012 | 110Microsoft SQL Server 2008 R2 | 100Microsoft SQL Server 2008 | 100Microsoft SQL Server 2005 | 90
新聞熱點
疑難解答