Software Requirements

Note that you will need SQL Server 2005, and in some cases, Microsoft Visual Studio 2005 to complete the labs included with each chapter. Although these products can be installed on a production server, it is not recommended that you do so. Instead, install these products and execute the labs in each chapter on a single development machine. The following software is required to complete the lab exercises:

• One of the following operating systems:

  • Microsoft Windows 2000 Server SP4

  • Windows 2000 Advanced Server SP4

  • Microsoft Windows Server 2003, Standard Edition SP1

  • Windows Server 2003, Enterprise Edition SP1

  • Windows Server 2003, Datacenter Edition SP1

• SQL Server 2005. For instructions on downloading and installing SQL Server 2005 Enterprise Edition, see the "Installing SQL Server" section of this Introduction.

• Visual Studio 2005 or Visual Studio 2005 SP1. A free 90-day evaluation of Visual Studio Professional Edition is available for download from the MSDN Web site at http://msdn2.microsoft.com/en-us/vstudio/bb188238.aspx. Visual Studio 2005 SP1 works with Visual Studio 2005 Standard Edition, Professional Edition, and Team Edition and is available from the Microsoft Download site.

• The AdventureWorks database; available as a separate download with the SQL Server 2005 samples from http://www.microsoft.com/downloads/details.aspx?FamilyID=&DisplayLang=en.

• Microsoft Data Access Components (MDAC) 2.8; available for free download from http://www.microsoft.com/downloads/details.aspx?FamilyID=&DisplayLang=en.

• Microsoft Web Application Stress Tool; available for free download from the MicrosoftDownload Center at http://www.microsoft.com/downloads/details.aspx?familyid=&displaylang=en.

• Microsoft Internet Explorer 6.0 SP1 or later.

• Internet Information Services (IIS) 5.0 or later.

Installing SQL Server 2005

A 180-day evaluation of SQL Server 2005 Enterprise Edition is available on the companion DVD or is available for download by performing the following instructions.

1. Browse to http://www.microsoft.com/sql/downloads/trial-software.mspx and click the "Download SQL Server 2005" link. You will need to complete a registration form that requires you to have a .NET Passport account.

2. Read and follow the instructions on the download page to download the SQL Server 2005 Enterprise Evaluation Edition. Locate the correct download file for your environment.

3. Once the install executable has been downloaded to your local machine, execute the downloaded file (SQLEVAL.EXE) and click Run to extract the setup files to your local development machine.

4. Browse to the location where you extracted the setup files. Execute  Setup.exe from the Servers folder to begin the installation process.

5. Select I accept the licensing terms and conditions and click Next.

6. Click Install from the Installing Prerequisites dialog box. Once complete, click Next to continue.

7. The installation will then perform a system configuration check. In the Welcome dialog box, click Next to begin the installation.

8. Once the System Configuration Check is complete, click Next.

9. Enter and name and company information in the Registration Information dialog box and click Next to continue.

10. Click Next to accept the defaults in the Feature Selection dialog box.

11. Click Next and accept the defaults in the Instance Name dialog box.

12. Click Next and accept the defaults in the Logon Information dialog box.

13. Click Next and accept the defaults in the Error and Usage Report Settings dialog box.

14. Click Install in the Ready to Install dialog box and wait for the installation to complete.

15. You will also have to download and install the AdventureWorks database, which is referenced in some of the chapter labs.

Installing Visual Studio 2005

Visual Studio 2005 Professional Edition is required to run some of the lab files provided in this book. To download and install a free 90-day evaluation edition of Visual Studio 2005 Professional Edition, refer to the following instructions:

1. Browse to http://msdn2.microsoft.com/en-us/vstudio/bb188238.aspx and click the Download link for the Visual Studio 2005 Professional 90-day trial. You will need to complete a registration form that requires you to have a .NET Passport account.

2. Read and follow the instructions on the download page to download the Visual Studio 2005 Evaluation Edition. Locate the correct download file for your environment.

3. Once the ISO image file has been downloaded to your local machine, copy it to a blank DVD-R, which will result in an exact copy of the installation media. Even though this copy is fully functional, the license is only valid for 90 days.

4. Once copied to a DVD-R, you can browse to the DVD drive and begin the installation by executing the  Setup.exe file.

5. Click Install Visual Studio 2005. The installation will begin by copying required setup files to a temp directory. When it is complete, click Next to continue the installation.

6. Select the I accept the licensing terms and conditions check box and click Next to continue the installation.

7. Click Install in the Select features to install dialog box and accept the default installation. Once complete, click Next to continue. The installation will take several minutes to complete; the time will vary depending on the speed of your development machine.

Installing the AdventureWorks Database

You will need to download and install a sample database for Adventure Works, a fictional retailer that is referenced in some of the labs in this book. To install the sample database, refer to the following instructions:

1. Browse to http://msdn.microsoft.com/vstudio/express/sql/default.aspx and click the Download icon.

2. Select the SQL Server 2005 Samples download and follow the instructions on the download page to save the case-insensitive collation DB installation package (Adventure-WorksDBCI.msi) to your local development machine.

3. Once the installation package has finished downloading, double-click the executable file and click Run to execute the Installer.

4. Click Next in the Welcome dialog box.

5. Select I accept the terms in the license agreement and click Next in the License dialog box.

6. Click Next and accept the defaults on the Destination Folder dialog box.

7. Click Install in the Ready to Install dialog box.

8. Click Finish in the Wizard Completed.

Installing Microsoft Web Application Stress Tool

The Microsoft Web Application Stress Tool is used to simulate multiple user requests to a Web site. To install this tool, refer to the following instructions:

1. Browse to http://www.microsoft.com/downloads/details.aspx?familyid=&displaylang=en, and click Download.

2. Select Run, and wait until the download completes and the installation begins. The setup file may take several minutes to download.

3. You should receive a security warning. Select Run to continue the installation.

4. Select Yes in the license agreement dialog box.

5. Select Next to install to the default destination directory.

6. Upon completion, the installation will display the readme documentation. Select OK and then select Finish to complete the installation.