Installing MS SQL Server 2008 R2 is freaky sometime. If You installed�Visual studio 2008 first and then try to install MS SQL 2008 R2 it may prompt an error. From the error log we can see something like this:
?
This Usually suggest you to install VS 2008 SP1 (Approx size 800.30 MB offline installer) which is very time�consuming�and annoying too. but changing the reg entry�may save�half of your day.
Steps:
HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/DevDiv/VS/Servicing/9.0
–�rename 9.0 to 9.0old or�anything�else.
Voila !!!
Now you are ready to install MSSQL 2008 R2 without installing VS 2008 SP1. But surely, installing VS 2008 SP1 is a good practice.
Good day
�