OMG. I ran into this insanity when trying to install SQL Server 2008 recently on my development box. I was able to install SQL2008 successfully on a clean Virtual PC with XP Pro SP3, and Visual Studio 2010 installed with no problems. So to my great surprise, it wouldn’t install on my Development box.
I decided like a typical geek to check the internet for a solution. Sure I could apply VS 2008 SP1 to my system, right. Not so fast, it crashed every time I tried to install it. Mind you that I had VS2003, VS2005, VS2008, and VS2010 installed at the time. So I decided to clean up my system. I mean, who needs all these releases of Visual Studio on their machine anyhow, right? Well… I think I do want several version sitting around to for experimentation. I decided that I would start using Virtual Hard Drive to that end, if I needed to.
So, off I went to back up all the wonderful stuff I might step on during this adventure… Of course I had to get a new 3Terabyte drive to make a clean backup and organize all the Microsoft Download. Several days later, I had everything backed up and was ready to start cleaning out my Visual Studio accumulation…
I started by removing the obvious VS 2008 items, rebooted and tried the SQL2008 installer again. The same message occurred. I removed all the framework and tools related to the VS 2008 version, rebooted and tried the SQL2008 installer again. The same message occurred. I removed VS2010, VS2005, VS2003, and related items. I removed all .net frameworks, and tools, rebooted and tried the SQL2008 installer again. The same message occurred. What kind of MADNESS is this? I decided to uninstall the SQL2005 Express, and SQL 2008 pieces that were installed prior to the message and try again from scratch…
Can you guess the outcome… Yup… The darn thing still wouldn’t install, and was still getting stuck on the VS208 SP rule.
OK Microsoft, pull you head out of you money hole and figure out how to make this work (like including the freakin sp1 patch, if it is a requirement).
Frustrated by this madness, I went ahead and clean my registry out (carefully exporting removed registry items). This step is not recommended for the faint at heart. I wasn’t too worried, because I have re-built this pc many a time and had a good back up and installation process…
I really didn’t want to build the pc from scratch, so I decided to take a wack at one of the setting in the registry (trick the installer into thinking the patch level was VS2008 sp1). Heck, I knew that their was no chance, that there was any VS installation on the pc at this point.
Quick Disclaimer: Try this at your own risk!
Find the following entry in the registry:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DevDiv\vs\Servicing\9.0\SP
Change the SP’s REG_DWORD value from 0 to 1.
Below is the recommended upgrade/installation path prior to removing every thing like I ended having to do.
Run the Visual Studio 2008 Service Pack Preparation Tool
Note: Installing a more recent service pack will uninstalled this http://support.microsoft.com/kb/945140″>VS 2008 SP1 automatically.
Run the SQL Server 2008 installer…
Good luck, Dale