SQL Server 2005 Express Installation

This is a step-by-step guide to install SQL Server 2005 Express Edition.

Pre-Requisites


There are a few pre-requisites for installing SQL Server 2005 Express Edition. You can view more information and the system requirements for SQL Server 2005 Express Edition by going to www.microsoft.com and enter SQL Server 2005 Express Requirements.

Please note that the MS .Net Framework 2.0 must be installed prior to installing SQL Server 2005 

Express Edition. The link to download this program is available from Microsoft in the System Requirements documentation above.

We also recommend ensuring that all Windows Updates have been performed prior to installing SQL Server 2005 Express Edition.

Step by Step Instructions


1. Download SQL Server 2005 Express Edition from Microsoft:

a.       Go to Microsoft's website (www.microsoft.com).

b.       Enter 'SQL Server 2005 Express Edition download' in the Search field and click the Search button.

c.       You will see a screen of results that match the search. Select a result that includes the downloadand proceed to download the file 'SQLEXPR.EXE'.

2. Double-click the SQLEXPR.exe file to install it:

a.       Use the default settings for the first few screens until you get to the Authentication Mode screen. 

Note: You can change the location that you are installing SQL Server 2005 Express to on the Feature Selection screen below by clicking the Browse button in the lower part of the screen.
image1.jpg 26.21 KB

b.       When you get to the Authentication Mode screen, use "Mixed Mode" Authentication, as shown below:

Note: The 'sa' password must pass Microsoft's complexity requirements and cannot contain illegal characters (use letters and numbers, ie. Password1234). 
3.       Click "Next" and continue the installation using default selections.

4.       Click Install.
5.       Once the SQLExpress installation is complete, open the SQL Server Configuration Manager: ( Start -> Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Configuration Manager).

6.       Your default server name (under SQL Server 2005 Services) is SQLExpress and it should be running as shown below. If it is stopped, right click on it and click Start.
image5.jpg 27.91 KB

7.       Click on the plus sign beside SQL Server 2005 Network Configuration and click on Protocols for 
SQLEXPRESS. 
image6.jpg 33.94 KB
a.       Double-click on Named Pipes and Enable it.

b.       Click OK.Double-click on TCP/IP and Enable it.

c.       Go to the IP Addresses tab on the TCP/IP Properties window and ensure that the network adapter that you wish to use is Active and Enabled. Click OK. 
image7.jpg 18.77 KB
d. You should be left with something like the screen below:
image8.jpg 15.35 KB


8.       Restart the SQL Server as outlined below:

a.       Click on SQL Server 2005 Services.

b.       Right-click on SQL Server (SQLEXPRESS).

c.       Click on Restart.

d.       Close the Configuration Manager.
image9.jpg 17.18 KB

Microsoft SQL Server Management Studio Express


Microsoft SQL Server Management Studio Express (SSMSE) provides a graphical management tool for SQL Server 2005 Express Edition. Installing this application is not required, but may be beneficial to maintain SQL Server 2005 Express. For more information or to download this application, go Microsoft's website (www.microsoft.com) and perform a search for 'SQL Server Management Studio Express'. The download file is 'SQLServer2005_SSMSEE.MSI'.

How did we do with this article?