資料庫伺服器(Virtual Machine)所在的Nutanix一臺主機由於故障,VM自動切換到另一臺主機,切換過程中VM會重新啟動,但是早上檢查的時候,發現點擊SQL Server Configuration Manager進去時報如下錯誤: ”Cannot connect to WMI pro... ...
資料庫伺服器(Virtual Machine)所在的Nutanix一臺主機由於故障,VM自動切換到另一臺主機,切換過程中VM會重新啟動,但是早上檢查的時候,發現點擊SQL Server Configuration 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 [0x80041010]”
不清楚什麼原因導致這個錯誤出現,但是"SQL Server Configuration Manager" gives "Invalid class [0x80041010]” when starting.這篇博客有提到如何解決這個問題,測試驗證了一下,發現這個命令確能解決這個問題。如下所示:
C:\Windows\system32>cd C:\Program Files (x86)\Microsoft SQL Server\100\Shared
C:\Program Files (x86)\Microsoft SQL Server\100\Shared>mofcomp sqlmgmproviderxps
p2up.mof
Microsoft (R) MOF Compiler Version 6.1.7600.16385
Copyright (c) Microsoft Corp. 1997-2006. All rights reserved.
Parsing MOF file: sqlmgmproviderxpsp2up.mof
MOF file has been successfully parsed
Storing data in the repository...
Done!
C:\Program Files (x86)\Microsoft SQL Server\100\Shared>
另外,不同版本的SQL 資料庫需要切換到到不同的目錄,例如SQL Server 2014,需要切換到C:\Program Files (x86)\Microsoft SQL Server\120\Shared下麵。一般需要根據具體情況酌情處理。
參考資料:
https://blogs.msdn.microsoft.com/spike/2012/03/19/sql-server-configuration-manager-gives-invalid-class-0x80041010-when-starting/