How to Set Up the Sample Environment
The sample environment consists of three parts whose installation is described below :
First, navigate to http://msdn.microsoft.com/vstudio/express/sql/download/. This is the location where you can download SQL Server Express 2005 SP2 or SQL Server Express 2005 SP2 with Advanced Features.
Choose your preferred option and download the file to your local computer.
When download has finished, run the executable.
To run SQL Server Express 2005 SP2 with Advanced Features on Windows Vista, Internet Information Services are required. Due to the "secure by default" approach, IIS are not installed by default after Windows Vista installation. IIS needs to be installed by running "Turn Windows Features on or off" in the "Programs" sections of the control panel. The options being checked in the screenshot below mark the minimum requirements for SQL Server Express 2005 SP2 width Advanced Features:
