SQL Server 2008 installation dependency problems with Visual Studio 2008 SP1

While installing SQL Server 2008 on a 64bit machine with Visual Studio 2008 SP1 installed you may come across a dependency check error:

 

Rule "Previous releases of Microsoft Visual Studio 2008" failed.
A previous release of Microsoft Visual Studio 2008 is installed on this computer. Upgrade Microsoft Visual Studio 2008 to the SP1 before installing SQL Server 2008.

 

This error is documented on KB 956139, "Actions that are required before you install SQL Server 2008 on a computer that has Visual Studio 2008 or the prerelease version of SQL Server 2008 installed".

 

I had Visual Studio SP1 (version 9.0.30729.1 SP) properly installed on my machine, so why this message? Well, with a quick monitoring using Process Monitor I noticed that the setup process was looking for ServicePack information on the WoW64 registry key, that was outdated:

image
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\DevDiv\VS\Servicing\9.0\IDE\1033

 

 

In order to fix it, you can update the SP and SPIndex entries to 1 and the SPName to SP1; just like the registry key at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DevDiv\VS\Servicing\9.0\BSLN\1033:"

image

Comments

  • Anonymous
    March 06, 2009
    Great !!! Thanks a lot for the tip saved me a lot of time :)

  • Anonymous
    March 21, 2009
    Thanks for this information! I had that same problem.

  • Anonymous
    May 06, 2009
    you are the MAN. You saved my time. I was ready to un-install whole VS 2008 to fix this issue.

  • Anonymous
    August 11, 2009
    Thanks, it worked, at least at first but, during the "Installation Progress" step, it showed the exact same error when running: Install_trin_aide_Cpu32_Action: CA_BlockOnVSSP0_x86. The installation ended but it showed a Failed status for: Integration Services Management Tools - Complete Business Intelligence Development Studio Management Tools - Basic This is a strange behavior because the same installation steps worked for a physical machine, the one with the issue is a virtual machine. Any thoughts?

  • Anonymous
    January 19, 2010
    I upgraded the Visual Basic 2008 with service pack 1, it installed successfully. Then I tried to install SQL 2008 Enterprise version onto Windows 7. Microsoft SQL Server 2008 Setup and Windows 7 Professional Error


The following error has occurred: Failed to open the registry key SOFTWAREMicrosoftMicrosoft SQL ServerMSSQL10.MSSQL64MSSQLServerSuperSocketNetLib or set its security descriptor: Attempted to perform an unauthorized operation.. For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.0.2531.0&EvtType=OpenKeyOrSetDescFailed

Need help ???------------------------------

  • Anonymous
    April 23, 2012
    If you already had all the settings in the reg correct.. delete the VC folder.. it will be re-created with the incorrect settings. Then you can change them to the correct (1) settings and it will work.

  • Anonymous
    November 11, 2013
    You're the best....thanks a lot, i solve my problem quickly.

  • Anonymous
    July 09, 2014
    Thank you so very much. I was at my wit's end till I came across your post

  • Anonymous
    July 16, 2014
    thanks a lot.................. you  save my time.....

  • Anonymous
    June 03, 2015
    Thanks a lot you rock save my time :)