Sign in
in
   
"It is the mark of an educated mind to be able to entertain a thought without accepting it."  -Aristotle

About Me

I am a co-founder of Notches, an early stage startup currently based in NYC. We are building a free, open reviews network that anyone can participate in and anyone can build on top of. You can find out more on our official blog.

Read more about my background.

Connect with me on...

Recent Readers

Flickr Photos

 

Warning:

This article is more than 45 days old. Given the speed at which the technology world moves, this post is probably somewhat out of date. Please keep this in mind when reading the post. If this is a tutorial, please check whether you are using the same versions mentioned in the article.

SQL Server installation problems on Vista? (Failed to compile the Managed Object Format)

I've been having issues installing SQL Server 2005 tools (i.e., Management Studio) on Vista. I know it works because I was able to get it installed on my tablet also running Vista - I just couldn't get it on my desktop.

SQL Server Setup Failed to compile the Managed Object Format (MOF) file

I thought it might be related to SQLEXPRESS installed as part of the VS.NET 2005 install, but that didn't seem to fix anything. As it turns out, this is related to a corrupt WMI repository - and the fix is quite easy.

C:\Windows\system32>winmgmt /verifyrepository
WMI repository is INCONSISTENT

C:\Windows\system32>winmgmt /salvagerepository
WMI repository salvage failed
Error code: 0x8007041B
Facility: Win32
Description: A stop control has been sent to a service that
other running services are dependent on.

C:\Windows\system32>winmgmt /salvagerepository
WMI repository has been salvaged

As you can see, I had to run it more than once - but it eventually fixed the problem. I clicked Retry and the install went through fine. Hope this saves time for anyone else running into the same issue.


View related posts

 

Jim said:

This information saved the small amount of sanity I have left.  Thanks.

February 3, 2007 5:20 PM
 

Jeannie said:

Thank you Tim!

February 6, 2007 8:30 AM
 

Jan Hyde said:

At last... a solution that worked.

:-)

February 28, 2007 3:00 AM
 

Jon said:

When I try this I get access denied messages, I take it this needs to be run in admin mode, in which case how do I do that?

March 11, 2007 12:18 PM
 

Jon said:

For anyone else who comes across this problem, right click the cmd.exe and run as administrator, then run the commands in the blog, will fail fisrt time round but just do it again and it works.

March 11, 2007 12:24 PM
 

Angel said:

Tim, I had proud of you!

Thanks!

March 26, 2007 5:26 PM
 

Paul said:

Tim, you are a scholar and a gentleman.  Thank you.

April 15, 2007 7:13 PM
 

Fabb said:

Dude, you saved me.  After hours of fighting, these simple instructions worked.  Had to run the salvage 3 times (took 5-8 minutes each time).

My wife wishes good things for u as a thanks.

April 19, 2007 2:40 AM
 

John C said:

Thank you soooo much!!!!

April 20, 2007 11:50 PM
 

Cliff Adams said:

Would someone please wax prophetic on these MOF files, the relevance of Vista to something concerning xpsp2 (XP service pack 2??!?), and WMI?  I hate not understanding the underlying cause of this $!@%!@^

April 24, 2007 2:49 PM
 

Tony said:

I'm getting the same problem but winmgmt /verifyrepository detects no problem with my WMI installation.  Any other suggestions? (I've now seen this more than a dozen times, trying different install techniques).

TITLE: Microsoft SQL Server 2005 Setup

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

SQL Server Setup Failed to compile the Managed Object Format (MOF) file c:\Program Files\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=29513&EvtType=sqlca%5csqlmofca.cpp%40Do_sqlMofcomp%40Do_sqlMofcomp%40x7349

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

BUTTONS:

&Retry

Cancel

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

May 22, 2007 11:43 AM
 

Tony said:

This Microsoft Knowledge Base article appears to be relevant:

http://support.microsoft.com/?kbid=926623

However, the problem in question does not appear to be fixed and the workaround described did not work for me. :(

May 22, 2007 12:14 PM
 

Kiranmayee said:

Hi,

After spending hours on trying to figure the cause of the error, and doing all sorts of installations, I came to your site through a google search and then, your fix helped me a lot.

Thanks a lot for sharing this tip.

The work around in the site, I too tried it and it did not work for me.

June 12, 2007 9:31 AM
 

Ed said:

Definitely, you are tha man!!!! Thanx... I almost slam the server against the floor...

June 25, 2007 7:08 PM
 

Zé Miguel said:

Thank's for share this precious information

September 21, 2007 9:49 AM
 

Jason Dodge said:

Thank you very much for this helpful post!

September 28, 2007 10:47 PM
 

Rubens Del Monte said:

thank you man!!!

you are de man!

October 9, 2007 4:14 PM
 

Maurice said:

Thank you, that helped me out, had to run as administrator; was "access denied" otherwise, had to run thre times to stop all the services.

October 15, 2007 1:41 AM
 

Ken said:

Thank you, thank you and thank you !!

October 17, 2007 3:51 PM
 

serkan yazıcıoğlu said:

you just saved a life, i was just going throw me and my notebook out the window. thanks...

October 27, 2007 5:33 PM
 

Derek Jee said:

U R  A Genius

November 6, 2007 5:13 AM
 

Chris said:

Saved another life, took 3 attempts on the salvagerepository but eventually it worked :) cheers

November 13, 2007 11:45 AM
 

Francis said:

Thank you. A simple solution to a big headache... This is what knowledge sharing is all about. !!!

November 15, 2007 3:31 PM
 

Mike said:

THANK YOU!

November 21, 2007 4:45 AM
 

George said:

thank you. fyi I had to run salvagerepository 8 times to stop all services.

November 30, 2007 8:48 PM
 

T said:

thanks Tim, works like a charm

December 8, 2007 1:57 PM
 

Rennie said:

Dude, my first born.. shall be named TIM!!!!

thanks for the help, you saved my sanity.  I just love following instructions that actually work. :-)  (hint hint MS)

February 17, 2008 11:02 AM
 

Gabe said:

WOOHOOOO!!!!!!!!! It works

April 1, 2008 8:56 AM