How to Install SQL Server

Step-by-Step Guide

1. 1

   Step 1: Put the SQL Server 2005 CD in the CD-Rom drive.

   Double click on the CD drive in your "My Computer" window if the CD does not auto-run.
2. 2

   Step 2: Choose your operating system type on the installation start screen.

   Most people will choose "x86-based operating systems." Then select "Server components, tools, Books online and samples" under the "Install" heading. , Click "Next." Click "Install" when the next window appears and then wait as the program installs prerequisite components.
   
   Click "Next."
   
   Click "Next." Then wait for the "System Configuration Test" to complete and click "Next."
   
   Enter your 25-digit product key in the boxes.
   
   Click "Next."
   
   Check the boxes of the parts of the program you want to install.
   
   Most people will choose "SQL Server Database Services," "Integration Services" and "Workstation components, Books Online, and development tools." Click "Next."
   
   Click "Next." Then click the radio button for "Use the built-in System account" on the next window.
   
   Click "Next."
   
   Choose a password and enter it in each of the two text boxes.
   
   Click "Next."
   
   Make sure the box next to "Accent – sensitive" is checked.
   
   Click "Next."
   
   Click "Next." Then view the pre-installation screen.
   
   Click "Install."
   
   The "Setup Progress" window will show you the progress of the installation, with green check marks showing completed actions and a progress bar showing the percentage completed.
   
   The installation should complete in 10 to 30 minutes.
   
   Click "Next." Click "Finish" on the final window to complete the installation.
3. 3

   Step 3: Read the "Terms and Conditions" and then put a check mark in the box to accept them.

4. 4

   Step 4: Watch for the "Installation Wizard" screen to appear.

5. 5

   Step 5: Fill out your registration information in the next window.

6. 6

   Step 6: Inspect the "Components to Install" screen.

7. 7

   Step 7: Select the radio button for "Default Instance" on the next window.

8. 8

   Step 8: Click the radio button for "Mixed Mod (Windows Authentication and SQL Server Authentication)."

9. 9

   Step 9: View the "Collation Settings" window and click the radio button next to "Collation designation and sort order."

10. 10

    Step 10: Look over the "Error and Usage Report Settings" and decided if you want to active either of them.

11. 11

    Step 11: Wait as the program installs.

Detailed Guide

About the Author