Installing SQL Server Express Edition on Windows 7 (Screen Shots)

Leave a comment (0) Go to comments

I have already posted various posts related to installing various versions of SQL Server on various Windows platforms, this post describes,

How to Install SQL server 2008 on Windows 7

Requirements:

Visual Studio 2010 or VS 2008 SP1 or .NET framework 3.5 or higher  and Windows Installer, if you already have it just move directly to set up

Step By Step Guide for SQL Server 2008 Express Edition Installation

Below I show the steps to install SQL Server 2008 Express edition on Windows 7.

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

Installing SQL Server Express Edition on Windows 7 (Screen Shots)

Click on option Installation, which , which is second option in the left panel and Click on “New installation or add feature to an existing installation” to start the Installation Wizard.


Installing SQL Server Express Edition on Windows 7 (Screen Shots)

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.

Installing SQL Server Express Edition on Windows 7 (Screen Shots)

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

Installing SQL Server Express Edition on Windows 7 (Screen Shots)

 

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

Installing SQL Server Express Edition on Windows 7 (Screen Shots)

Step 5: Check Accept the terms and click NEXT

Installing SQL Server Express Edition on Windows 7 (Screen Shots)

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

Installing SQL Server Express Edition on Windows 7 (Screen Shots)

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.

Installing SQL Server Express Edition on Windows 7 (Screen Shots)

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.

Installing SQL Server Express Edition on Windows 7 (Screen Shots)

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.

Installing SQL Server Express Edition on Windows 7 (Screen Shots)

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

Installing SQL Server Express Edition on Windows 7 (Screen Shots)

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

NT AUTHORITY\NETWORK SERVICE and Click Next.

Installing SQL Server Express Edition on Windows 7 (Screen Shots)

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 ).

Installing SQL Server Express Edition on Windows 7 (Screen Shots)

Step 13: Click Next

Installing SQL Server Express Edition on Windows 7 (Screen Shots)

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

Installing SQL Server Express Edition on Windows 7 (Screen Shots)

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

Installing SQL Server Express Edition on Windows 7 (Screen Shots)

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

Installing SQL Server Express Edition on Windows 7 (Screen Shots)

Step 17: Now Close this window

Installing SQL Server Express Edition on Windows 7 (Screen Shots)

Close

Installing SQL Server Express Edition on Windows 7 (Screen Shots)

Exit this

At last Exit this window. Installation is complete.Install SQL Server 2008 SP2.

EOF - Installing SQL Server Express Edition on Windows 7 (Screen Shots), SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.