SQL Configuration Manager Problem

Question

Post reply

SQL Configuration Manager Problem

mobasha

SSCertifiable

Points: 5334
More actions
July 13, 2008 at 1:53 pm

#129914

hello all.
i have sql server enterprise 2005 on cluster server.
my windows user is sysadmin on the sql server, when am trying to use sql configuration manager i get "access denied wmi provider"
also when i login as the sql server account am still getting the same msg.
can u tell me whats wrong? and how to fix this.
..>>..
MobashA

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

Perry Whittle SSC Guru Points: 233864 More actions · Answer 1

check this link

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1721211&SiteID=1

it may be of some use

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

MannySingh SSChampion Points: 12465 More actions · Answer 2

Try this solution:Goto Start-RUN-CMD (command Prompt)

then run this command. whatever the path of your SQL Binaries....

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

Maninder
www.dbanation.com

mobasha SSCertifiable Points: 5334 More actions · Answer 3

i have no file like mofcomp in the path C:\Program Files\Microsoft SQL Server\90\Shared?

..>>..

MobashA

EdVassie SSC Guru Points: 60445 More actions · Answer 4

mofcomp is a system utility. It compiles the mof file that is in the location specified. One of the main uses of compiled mof files is to make additional facilities available to GPO processing.

Google can tell you more about mofcomp, mof files and GPOs if you want this information.

Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

mobasha SSCertifiable Points: 5334 More actions · Answer 5

so if i found mofcomp in the windows files i can still ues it, right..

..>>..

MobashA

sudhakara SSCrazy Eights Points: 9425 More actions · Answer 6

Mani Singh (7/13/2008)
Try this solution:Goto Start-RUN-CMD (command Prompt)
then run this command. whatever the path of your SQL Binaries....
C:\Program Files\Microsoft SQL Server\90\Shared>mofcomp "C:\Program Files\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof"

hi.. i am also having the same problem.but while running this command from command prompt its giving the error message "'mofcomp' is not recognized as an internal or external command,

operable program or batch file."

Sql Server 2005 standard edition & windows xp

Kindly let me know how to resolve this issue.

Perry Whittle SSC Guru Points: 233864 More actions · Answer 7

are you copying and pasting the text from this site to the command prompt?

if not, can you post the exact command you are using?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

sudhakara SSCrazy Eights Points: 9425 More actions · Answer 8

Perry Whittle (1/25/2010)
are you copying and pasting the text from this site to the command prompt?
if not, can you post the exact command you are using?

i have tried the same command what is there in the forum ...

karthik.kenchaiah SSC Journeyman Points: 79 More actions · Answer 9

An error occurred while processing item 1 defined on lines 4 - 7 in file C:\Prog

ram Files\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof:

this is the error i got when i was running the above cmd

can anyone please help me???

sakareem.net Newbie Points: 7 More actions · Answer 10

try this first

go to c:\windows\system32\wbem

run the below command

mofcomp "C:\Program Files (x86)\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof". for sql server 2008

mofcomp "C:\Program Files\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof". for sql server 2005

EX:

{

C:\WINDOWS\system32\wbem>mofcomp "C:\program files\microsoft sql server\90\share

d\sqlmgmproviderxpsp2up.mof"

Microsoft (R) 32-bit MOF Compiler Version 5.2.3790.3959

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!

}

try to open congiguration manager will work..

if not still..

Copy the file: "framedyn.dll" from folder: "C:\WINDOWS\system32\wbem" TO folder: "C:\WINDOWS\system32" . it maybe works~

coolmind1414 SSC Journeyman Points: 83 More actions · Answer 11

This worked perfectly fine.

Thanks a lot

Awesome

sakareem.net (2/7/2012)
try this first
go to c:\windows\system32\wbem
run the below command
mofcomp "C:\Program Files (x86)\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof". for sql server 2008
mofcomp "C:\Program Files\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof". for sql server 2005
EX:
{
C:\WINDOWS\system32\wbem>mofcomp "C:\program files\microsoft sql server\90\share
d\sqlmgmproviderxpsp2up.mof"
Microsoft (R) 32-bit MOF Compiler Version 5.2.3790.3959
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!
}
try to open congiguration manager will work..
if not still..
Copy the file: "framedyn.dll" from folder: "C:\WINDOWS\system32\wbem" TO folder: "C:\WINDOWS\system32" . it maybe works~

SanjeevBaranwal Old Hand Points: 397 More actions · Answer 12

What if the .mof file is missing.I am facing this problem right now for SQL 2012.Please reply.