Guy Barrette, Microsoft, Regional Director, Montreal, Canada, Visual Studio, .NET Expertise SQL Server 2008 requires VS 2008 SP1 - Guy Barrette

Guy Barrette

Microsoft Regional Director, Montreal, Canada

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.

Posted: Aug 07 2008, 07:14 AM by guybarrette | with 14 comment(s)
Filed under:

Comments

DotNetKicks.com said:

You've been kicked (a good thing) - Trackback from DotNetKicks.com

# August 7, 2008 9:21 AM

quachnguyen said:

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

Thanks

QuachNguyen

# August 7, 2008 9:29 AM

guybarrette said:

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.

# August 7, 2008 9:41 AM

Peter Tilbrook said:

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

# August 7, 2008 10:38 AM

guybarrette said:

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

# August 7, 2008 10:48 AM

Fred Beiderbecke said:

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.

# August 7, 2008 1:15 PM

Daniel said:

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.

# August 7, 2008 5:30 PM

tomsteele said:

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

# August 7, 2008 5:35 PM

voodoo said:

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

# August 7, 2008 6:08 PM

kamii47 said:

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

# August 8, 2008 2:03 AM

Holesinswiss said:

Here is the relevant MSKB article:

support.microsoft.com/.../956139

# August 8, 2008 2:21 PM

Kalle said:

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.

# October 19, 2008 10:58 AM

Theo said:

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

# May 16, 2009 11:15 AM

Christopher said:

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

# June 14, 2009 6:17 PM
Leave a Comment

(required) 

(required) 

(optional)

(required)