Monday, September 30, 2013

How to resolve issue with SQL configuration manager?

Got the Below error message while trying to invoke Configuration manager.

Error 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 and later servers with configuration Manager. Inavlid namespace [0x8004100e].

Resolution : Need to search for .mof files in c:\program files\microsoft sql server folder.
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! If it throws error then we need to rebuild the WMI repository as below:

net stop winmgmt
c: cd %systemroot%\system32\wbem
rd /S /Q repository
regsvr32 /s %systemroot%\system32\scecli.dll
regsvr32 /s %systemroot%\system32\userenv.dll
mofcomp cimwin32.mof
mofcomp cimwin32.mfl
mofcomp rsop.mof
mofcomp rsop.mfl
for /f %%s in ('dir /b /s *.dll') do regsvr32 /s %%s
for /f %%s in ('dir /b *.mof') do mofcomp %%s
for /f %%s in ('dir /b *.mfl') do mofcomp %%s
echo DONE
pause

No comments:

Post a Comment