I do not know how many people are trying to install SQL Server 2008 R2 Sp1 on a windows 7 machine. But I have been facing issues with the software lately. But this is how I got to install it.


Prerequisite for SQL server 2008 R2 SP1 is Microsoft .net Framework 3.0 - which is already there in the system as Win 7 come with 3.0 with the base image.

so go ahead and install the application directly.


Command line that would install it is 


"\\Sharename\MS SQL Server 2008 R2 SP1\setup.exe" /configurationfile="\\Sharename\MS SQL Server 2008 R2 SP1\configurationfile.ini" /iacceptsqlserverlicenseterms

which would install SQL server according to the commandlines specified in configuration file.


some of the issues that I have faced while installing is the error managed sql server fixsqlregistrykey

There are many application that have .net frame work 4.0 as s prerequisites. So uninstall .net framework 4.0 before the installation so that it does not error out the installation and then install it back as soon as the installation is complete.