SQL Server 2008 requires VS 2008 SP1

If your installing SQL Server 2008 on a box that already has Visual Studio 20008 pre SP1, you need to apply VS 2008 SP1 before installing.  If not, you'll get this message:

VS 2008 SP1 should be available in a few days.

Thanks to Andrew Brust for pointing this out.

17 Comments

  • which mean, I must install VS 2008 SP1 beta?or Beta Full edition?

    Thanks
    QuachNguyen

  • Which mean that if you have VS 2008 presently installed on your computer, you have to install VS 2008 SP1 before installing SQL Server 2008. The SP1 for VS 2008 will be released in just a few days.

  • Um that would be 2008 SP1 - not 20008 SP1 lol!

  • Peter: OMG! That would have been a very loooooong wait. Thanks for pointing this out.

  • Isn't it a bit ridiculous that you need sp1 beta and vs2008 sp1 beta for a production product?

    Even after installing both of those it is erroring out saying I need sp1 for VS2008 installed.

    Argh.

  • You can trick the dependency check by renaming the following registry key during install of SQL 2008

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DevDiv\VS\Servicing\9.0

    No guarantees, but SQL 2008 will install and run.

  • What about the [arch]\Setup\VS90sp1-KB945140.msp file? Is that it?

  • I hope it is out in a couple of days. I won't move forward until VS.NE 2008 SP1 is release

  • Yep and VS 2008 SP1 will be available after 11th August

  • I hve Visual Studio 2008 + SP1 installed. Got this error message, I reistalled SP1 while SQL server installer window was open, then pressed re-run and the installation proceeded.

  • Just ran across the same - even tough I had SP1 installed already. It turned out that under the 1031 country reg the SP had not been updated:
    HKLM\SW\Wow6432Node(Vista64)\M$\DevDiv\VS\Servicing\9.0\Pro\1031\
    SPName was RTM instead of SP1
    SP was 0 instead of 1
    SPIndex was 0 instead of 1
    After patching these three SQL2008 would install.
    Hope it helps others...
    Cheers
    Theo

  • Great comments Theo. I spent all day trying to fix the problem. It was catch 22. VS 2008 full version installed (not Express). SQL Server was asking to update VS with SP1. SP1 would not load due to Express version detected (which was not!).
    I changed the index values in the registry keys and all works fine now.

    Thks a lot

  • Daniel, your suggestion rocks and helped me "trick" the installation (I had official VS 2008 SP1 installed but it was not detected by the setup due to unknown reason). Thanks a million, mate!!!

  • Thanks Theo!
    Appreciate your time and valuable advice!
    It worked for me!

  • HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DevDiv\VS\Servicing\9 will do the work but you have to have sp 1 in 9.0 and in IDE and In VSTS subkeys also :))) ! Super ! I spent 2 days trying to find out what was wrong.

  • Thanks a lot Theo, helped me aswell :)

  • This is a really great installer you got there Microsoft. Haven't clicked that much in years to get a simple thing installed. Looking forward to the next one!

Comments have been disabled for this content.