If you have installed SQL Server 2005, it is likely you have installed the samples as well. In my case, I installed what I thought to be everything, realizing that the samples did not install. When I went in through the normal set up to install them, I was not able to.

Thankfully, I found a workaround that prevented me from having to uninstall and reinstall…

1. Go to Start –> Control Panel –> Add/Remove Programs
2. Click “Change” for SQL Server 2005
3. Entering the setup from this approach, you will have the option to add/change components.
4. Follow the wizard, and when given the option to add components, choose the “Workstation Components” checkbox.
5. Change the installed components as you would with any other Microsoft application.
6. Complete the wizard.

To actually install the samples, you will need to:

1. Navigate to n:Program FilesMicrosoftSQL Server90ToolsSamples and double-click SqlServerSamples.msi to launch the installer.
2. Navigate to the the installed location (default is n:Program FilesMicrosoftSQL Server90Samples) and have at it!

Note: These steps do not apply to recreating a sample database that has been deleted. For that, you will correct that using installation scripts, which can be found easily in BOL.

Related Information:

1. SQL Server 2005 Service Pack, Version, Edition

   Here is how I find out what SQL Server 2005 DB I am playing with: Log into any DB in...

2. SQL Server 2005 Licensing Costs and Pricing Example

    Processor Licensing Model. Under this model, a license is required for each physical or virtual processor accessed by an...

3. BPA 10.1.3.4 Windows Install with XE

   I have just had a heck of a time with installing BPA (Architect) Evaluation on a Windows Server 2003 machine....

4. Install Oracle Apex 3.2 on XE and XP Pro - Video Walkthrough Tutorial

   This tutorial is a supplment to the install video linked to below. It takes you through the process of installing...

5. Oracle XE 10g Windows Install - Video Walkthrough Tutorial

   This tutorial article is meant to provide a visual guide to the process of installing Oracle express edition (XE) onto...

6. Oracle APEX Tutorial 10 - Access Control - Part 2 - Video Training

   Security. We hear about it everywhere. Make this more secure, make this less secure. In the computer industry this is...

7. APEX 3.2 Tutorial Preparation and OEHR Sample Data - Video Walkthrough

   This tutorial video and article is meant to help you setup your APEX installation so you can proceed through the...