SQL Server 2005 Install Samples

Posted on Feb 1, 2006 in Technical Tips | 0 comments



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.

Bookmark and Share

Related Information:

  1. SQL Server 2005 Service Pack, Version, Edition
    Here is how I find...
  2. SQL Server 2005 Licensing Costs and Pricing Example
    Processor Licensing Model. Under this...
  3. Install Oracle Apex 3.2 on XE and XP Pro – Video Walkthrough Tutorial
    This tutorial is a supplment...
  4. SSIS Tip – Save Package to MS SQL Server (Integration Services)
    In order to save your...
  5. BPA 10.1.3.4 Windows Install with XE
    I have just had a...
  6. Server Technologies
    M&S Consulting has experience designing...
  7. JDeveloper 11g Tutorial – Install Steps (11.1.1.3.0)
    New versions of JDeveloper 11g...
  8. WebLogic 11g (10.3.4) Install on Windows – WLS 11gR3
    I documented the steps I...

Leave a Reply