Click here to Skip to main content
13,004,123 members (109,928 online)
Click here to Skip to main content
Add your own
alternative version

Tagged as


7 bookmarked
Posted 24 Dec 2011

How to Install SQL server 2008 on Windows 7

, 24 Dec 2011
Rate this:
Please Sign up or sign in to vote.
In my previous post I show How to Install IIS on Windows 7. Now I am going to show How to Install Microsoft SQL Server 2008 Express Edition. First you need the installer, download it from here. Requirements: Visual Studio … Continue reading →

In my previous post I show How to Install IIS on Windows 7. Now I am going to show How to Install Microsoft SQL Server 2008 Express Edition.

First you need the installer, download it from here.


Visual Studio 2010 or VS 2008 SP1

Step 1: Double click on the installer. It will take some time to extract. After that an window  will open as follow.

First window of installation

Step 1

Step 2: From this window click on the Installation menu (See Left). Now there will be appear some option under Installation. From right, click on the option New SQL Server stand-alone installation or add features to an existing installation.

Note: After Clicking on that a window may appear as bellow. Just click on the button Run Program of that.

Click Run Program


Step 3: Now setup will take a moment to complete some operation. To continue there can not be any operation with status failed. If any operation fails then it will not be possible to continue installation. Click OK

Every operation should be passed

Step 4

Step 4: This is express edition so I do not need to enter any product key. Just Click on Next


Step 4

Step 5: Check Accept the terms and click NEXT

Check Accept Terms & Condition and Click Next

Step 5

Step 6: Now Click Install button. Some setup support files will be installed.

Install Setup Support Files


Step 7: Now again It needs some operation to be completed. Every operation must be  passed or warning or skipped. If any operation fails then it is not possible to continue. Click Next.

There can not be any operation with failed status

Step 7

Step 8: Now select the features which do you need. Here I am selecting Database Engine Services, Busines Intelligence Development Studio, Management Tools basic & SQLl Client Connectivity SDK. Click Next.

Select Services

Step 8

Step 9: Here we need the name and instance ID. I am selecting Default Instance but keep the name “SQLExpress” in your mind for future use. Click Next.

Check Default instance

Step 9

Step 10: Now a window will appear  and it will show the space required and available. Click Next.

Click Next

Step 10

Step 11: Here select the account name from the dropdown list for SQL Server Database Engine-



Step 12: Now select which mode do you want to use. Here I am selecting the Mixed mode.
For mixed mode I have to provide the password for the root account (username “sa” default) and adding my current user by which i will also be able to access database engine without default administrator account (username : sa ).


Step 12

Step 13: Click Next

Click Next

Step 13

Step 14: Now again every operation must be passed or skipped. If there is any operation with status failed then installation will not be possible. Click Next

There must not be any operation with status failed.

Step 14

Step 15: Now finally it is going to start the installation. Click Install

Start Installation

Step 15

Step 16: Now wait till installation is complete. Setup is complete. Click Next


Step 16

Step 17: Now Close this window



Exit this

Exit this

At last Exit this window

Installation is complete.Install SQL Server 2008 SP1. If you face any problem just let me know. After installation to see how to connect and perform basic operation by Management Studio see my next post.



This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Razib Chandra Deb
Bangladesh Bangladesh
No Biography provided

You may also be interested in...

Comments and Discussions

QuestionRestart computer as failed while i m installing SQL Server 2008 Pin
virag nirmalkar8-May-14 5:06
membervirag nirmalkar8-May-14 5:06 
Questionabout database error Pin
Member 1034109716-Oct-13 18:15
memberMember 1034109716-Oct-13 18:15 
Bugproblem in connecting to server Pin
Member 97237442-Jan-13 5:54
memberMember 97237442-Jan-13 5:54 
Bugproblem Pin
Member 97237442-Jan-13 5:45
memberMember 97237442-Jan-13 5:45 
Questionconnect to server SQL 2008 Pin
MiBeloved27-Jun-12 12:53
memberMiBeloved27-Jun-12 12:53 
GeneralRe: connect to server SQL 2008 Pin
Razib Chandra Deb27-Jun-12 22:13
memberRazib Chandra Deb27-Jun-12 22:13 
Open Sql Server Configuration Manager and see weather Sql Server is running or not.
if not running select it and start it.

if it is running then problem is somewhere else.

Did you try to connect to your SQL Server by SQL management studio?

which authentication mode did you select in the time of installation Mixed mode or Windows mode.

Please let me know.

GeneralRe: connect to server SQL 2008 Pin
MiBeloved28-Jun-12 15:56
memberMiBeloved28-Jun-12 15:56 
GeneralRe: connect to server SQL 2008 Pin
MiBeloved30-Jun-12 13:40
memberMiBeloved30-Jun-12 13:40 
GeneralMy vote of 1 Pin
Selvin24-Dec-11 16:57
memberSelvin24-Dec-11 16:57 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web01 | 2.8.170627.1 | Last Updated 24 Dec 2011
Article Copyright 2011 by Razib Chandra Deb
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid