Background:
Windows Server 2016 Core
SQL Server 2016 Enterprise (obviously 64-bit)
Windows Failover Cluster
SQL Failover Cluster
I am attempting to connect to SQL Server Configuration Manager via my local Computer Management connecting to the database server. I expand Services and Applications and click on SQL Server Configuration Manager. However, this is the error message I see:
Connection failed. 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 namespace [0x8004100e]
I have tried this in the command prompt:
mofcomp "%programfiles(x86)%\Microsoft SQL Server\130\Shared\sqlmgmproviderxpsp2up.mof"
Which then says:
MOF file has been successfully parsed Storing data in the repository... Done!
Then I restarted WMI service, closed Computer Management, and reopened it. And I got the same error.
Does anyone know how to resolve this?
Thank you!
P.S. - I have posted this on another forum a few days ago and no one could help me resolve this issue
Update 1: I have turned off the firewalls on both client and server and attempted to connect to Configuration Manager which gave me the same error message
Update 2: My user account has domain admin privileges
Update 3: I ran the Get-WMIObject command and got SystemDirectory, BuildNumber, RegisteredUser, SerialNumber, and Version information so I'm guessing that I am allowed to access WMI remotely?
Update 4: I have SQLServerManager13.msc (located in the server's C:\Windows\SysWOW64) and attempted to open it on my local machine which gave me the same WMI error.
Update 5: I ran SQL Server repair on both SQL nodes (still same message)
Update 6: I ran winmgmt /verifyrepository and winmgmt /salvagerepository and both stated that the WMI repository is consistent
My solution: You need to have SQL Server 2016 installed on your local machine. Then you can use Computer Management to connect to your remote SQL Server Configuration Manager stuff.