Menu
I installed the evaluation version of SQL Server 2008 R2 after removing SQL Server 2008 R2 Express. SQL Server Configuration manager was still accessible after the un-installation but now it is no longer accessible with this error:
Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 servers with SQL Server Configuration Manager. Invalid class [0x80041010]
The file sqlmgmproviderxpsp2up.mof is found in the folder C:\Program Files (x86)\Microsoft SQL Server\100\Shared on my PC. I tried to type in the command prompt:
C:\Program Files (x86)\Microsoft SQL Server\100\Shared>mofcomp "C:\Program Files (x86)\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof"
but still get the access denied error. I am unable to find the answer for this issue, does anyone have any ideas?
670
In SQL Server Configuration Manager, in the left pane, select SQL Server Services. In the results pane, right-click SQL Server (MSSQLServer) or a named instance, and then select Start, Stop, Pause, Resume, or Restart.
On the Action menu, click Connect to another computer. In the Select Computer dialog box, in the Another computer text box, type the name of the computer you want to manage, and then click OK. Computer Management displays the services running on the remote computer.
Make sure that Allow Remote Connections is enabled on sql server properties. Check if TCP/IP is enabled. Configure to allow SQL Server in Firewall Settings. Check for working fine SQL Server Browser.
I've got access denied error too. And my solution:
cmd
then type in the command prompt:
C:\Program Files (x86)> Microsoft SQL Server\100\Shared>mofcomp "C:\Program Files (x86)\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof"
it worked for me.
50
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
