Mar 3, 2012

Install SQL Server 2008 - Step by Step Guide - 1

A Step by Step guide to installing SQL Server 2008 simply and successfully with no prior knowledge
Developers and system administrators will find this installation guide useful, as will seasoned DBAs. It will teach you the basics required for a typical, problem-free installation of SQL Server 2008, allowing you to add other components later if you wish.
Remember to install the .Net Framework 3.5
Before you start the installation, you’ll need to install the .Net 3.5 Framework. This comes pre-installed on Windows 2008 Server, but for earlier versions of Windows, you’ll need to install it first. This is a straightforward pre-requisite and is usually included as part of the SQL Server 2008 installation. However, if you don’t know how to do this, or for some reason you need to download it, check out the guide Installing .Net Framework 3.5 for SQL Server 2008.
Once this Framework in installed you can commence the installation of SQL Server 2008.
STEP 1 : Copy the installation files
First off I’d recommend you copy the entire directory structure from the SQL Server 2008 installation disc to the C: drive of the machine you are going to install it on.
Although this means you need to grab a cup of coffee whilst it’s copying, this has three advantages:
  • It makes the installation process much faster than running it from CD/DVD once it gets started.
  • It allows you to easily add or remove components later, without having to hunt around for the CD/DVD.
  • If your media is damaged and a file won’t copy, you get to find out now, rather than halfway through the installation.
Here’s what my system looks like after the copy:
STEP 2 : Setup.exe
Double click on the setup.exe file.
After a few seconds a dialog box appears:

This will disappear from the screen and then the main installation page appears:

STEP 3 : SQL Server Installation Center
Click on the Installation hyperlink on the left hand side of the screen:
STEP 4 : SQL Server Installation Center
Click on the "New Server stand-alone installation" link on the right side of the screen:

The following dialog appears on the screen whilst the install program prepares for installation:

After a minute or so (the timing will vary according to your system), the following screen appears:

STEP 5 (optional) :
If any checks have failed, click on the Show details button or "View detailed report link" to find out the cause, correct it, then click on the Re-run button to perform the checks again.
STEP 6 : Product key
If all checks have passed, click on the OK button. After a few moments, the option to select the edition and to enter the license key (or “product key”) will appear. Note that the product key box may already be populated, depending on which edition you have. Don’t enter the product key we’ve shown here, it won’t work on your system!:
STEP 7 : License Terms
Enter the product key into the box, or choose the free edition if you're evaluating SQL Server 2008, and click on the Next button:
Click in the "I accept the license terms" check box, then click on the Next button again.
STEP 8 : Setup Support Files
The following screen appears; click on the Install button:
The following screen will appear whilst Windows Installer prepares itself for the installation. This will take a short while:
After 30 seconds or so the dialog appears again:

STEP 9 : Setup Support Rules
If all is well, the following screen appears:
Click on the Next button again.
STEP 10 : Feature Selection
Select the features you want to install.
At a minimum, the following are useful (I'd argue essential), but what you need will depend on your needs:
Click on the Next button.
STEP 11 : Instance Configuration
After a short while the following screen appears:
For most installations, keep the default settings.
Click on the Next button.
STEP 12 : Disk Space Requirements
This screen just tells you if you have sufficient disk space on the drive you’re installing to, and what’s going to be installed where.
Click on Next

READ PART 2 OF THIS ARTICLE - Click Here to Read Part 2 of this Article >> >>


  1. It was really impressed by seeing this article, it was very intresting and it is very useful for <a href="</a>MSBI Learners.. I came to know that Biginfosys is also one of the best MSBI online training institute at hyderabad.

  2. Thank you provide valuable informations and iam seacrching same informations,and saved my time

  3. Nice information. Our institute Is the Leading online institute in

    Hyderabad, India to provide INFORMATICA online trainings with the real

    time experts and certified professionals. alot

    Informtica ONLINE TRAINING.


  4. mygoodonlinetraining is the one of the most leading Online Training Institutes in the World. This is providing various courses like SAP, Oracle, JAVA, Microsoft sas and many more through Online. the obiee online training with the real time experts and certified professionals.we will provide more Informationsvisit my sites.

  5. The information which you have provided is very good. It is very useful and easily understood. who is looking for SAS Online Training.

  6. I just see the post i am so happy the post of information's.So I have really enjoyed and reading your blogs for these posts.Any way I’ll be subscribing to your feed and I hope you post again soon.
    MSBI Training in Chennai

  7. Thank you for giving information. Please let us know and more information get post to link.

    weblogic tutorial

  8. Awe! What An Blog Very Helpful and interesting Really A great center for acquiring knowledge.Very Helpful Post And Explained Very Clearly About All the things.Very Helpful. Coming To Our Self We Provide Food Service Parts .Really Thankfull For the blogger providing such a great information.Thank you. Have a Nice Day.


  9. This Blog is very helpful and useful,came to know that i should be strong in my basics and this blog helps me to improve it,Immediate Care Services Provided by Us.Thanks For Posting.I Am refereed by my friend to this blog and i also want to refer my other friends to this blog.

  10. Thank you for sharing beneficial information nice post Bala Guntipalli



Thanks for your visit to this blog.
We would be happy with your Queries/Suggestions.