SQL Server 2005 - Cannot connect to WMI provider

feesu
feesu used Ask the Experts™
on
Hi Experts,

I have right-clicked on the sql server name in the studio manager and stopped the sql server to be able to copy my mdf files to my external storage.

After trying to open my sql server again I got a message saying not able to open it "a network related error..."

I went to programs/sql server configuration manager to start the stopped server, and got the following message:
"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 Configuration Manager.
Invalid Class [0x80041010]"

What do I do?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
The solution is to go to a command prompt and then run mofcomp.

C:\Program Files\Microsoft SQL Server\90\Shared>mofcomp "C:\Program Files\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof"

The output will look like below


Microsoft (R) 32-bit MOF Compiler Version 5.1.2600.2180
Copyright (c) Microsoft Corp. 1997-2001. All rights reserved.
Parsing MOF file: C:\Program Files\Microsoft SQL Server\90\Shared\sqlmgmprovider
xpsp2up.mof
MOF file has been successfully parsed
Storing data in the repository...
Done!

On servers, the .mof file will be sqlmgmprovider.mof.

Author

Commented:
Ok I got the "Done" message. Now I go directly to the Studio Management and try to connect to my server I get the same "A network-related error or instance-specific error..." message!

Author

Commented:
I restarted my PC and it worked fine now. Thanks.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial