SQL 2005 Standard on Vista RTM

Hi All,

I've read a number of threads on here where users have managed to get 2005 working on Vista RTM.

I'm having no such luck however. The issue I have is as follows:

Clean Install of Vista RTM Ultimate 32bit.

Attempt to install 2005 Standard.

This error appears:

SQL Server Setup Failed to compile the Managed Object Format (MOF) file D:\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.

I've read elsewhere that I need Sp2 of SQL Server. I can't install SQL server though so that makes it hard to apply a service pack.

I have also tried the above with the Developer edition of Sql 2005.

Has anyone encountered this issue and got past it

T.I.A.

Glen

Surely Microsoft didn't release Vista without having its latest version of their database working on it

Samuel Lester - MSFT wrote:

Can you read through this thread and see if it applies It suggests that there is a WMI configuration issue. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=124864&SiteID=1 Thanks, Sam

Hi,

Yes I went through the steps with the WMI batch etc yesterday without any difference to the outcome.

Thanks.

This corrected my problem with the install of SQL Server 2005 Express SP 1 and SP2 CTP.

The problem was my WMI Repository was corrupt.   I went to salvage it and it said it failed, but it sent a stop code to the service.  I waited 10 seconds after I got this message and tried to salvage it again.  It took about 2-3 minutes for the command to execute.  Here are the results I experienced.

Microsoft Windows [Version 6.0.6000]
Copyright (c) 2006 Microsoft Corporation.  All rights reserved.

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 ser
vices are dependent on.

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

C:\Windows\system32>

I did this while the installation of SQL Server Express had the error and was prompting a retry.  When it stated that the WMI repository had been salvaged I clicked on Retry.  Viola!  It continued and completed the installation.

Good Luck.  It took two days of searching for me to come across this post.

Thank you Jin!

I had the exact same experience and the above worked for me as well... Note, I also had to do two salvage's.

Thanks...Rich

Excellent Post this resolved my problem with installing SQL Express for Office Accounting Pro 2007 on Vista.

Many Thanks.

This worked fine for me too !

The only problem is to stop winmgmt.exe before executing your solution.

'net stop winmgmt.exe' should be run as administrator.

Many many Thanks for this advice. After looooong time of try and search I found this article and it worked for me too.

On my PC the touble started after Visusal Studio install and applying all sp from windows update on Vista Business.

Also here two savagings (one after stop) - while Setup of SQL Server developer 2005 complains not to be able to run sqlmgmproviderxpsp2up.mof have been necessary.

Thanks

Wolfram