Sqlexpress 2005

Author:                       Lance Claase

Date:                           September 2009

Revised:                     September 2009

Audience:                 IT in house

Summary                    This will demonstrate the install process of Sqlexpress 2005 and configuration.

Contents:

· Introduction

· Step 1:Installing Sqlexpress

· Step 2: Sql configuration manager

· Step 3: Sql server browser

· Step 4: Windows firewall

· Step 5: Sql server client network utility

· Conclusion

Introduction:

Sqlexpress is a free Sql manager similsr to MSDE. The difference between the two is this version of Sql allows one to have a 4 Gb database instead on MSDE’s limitation of 2 Gb. Once the limitation has been reached, the user will need to purchase the full version of Microsoft Sql Server. There are other limitations involved and include:

- a one cpu limitation

- 1 Gb memory limitation

- 4 Gb database limitation

Step 1: installing Sqlexpress

Double click on the SQLEXPR32.exe to start the install

(fig 1)

Select the accepting terms and conditions check box

(fig 2)

The install will begin

(fig 3)

The next screen

(fig 4)

The system configuration test – all will need to be passed

This part of the install checks the PC to see if there are any errors that Sql will experience during the installation. If there are any errors, they will be displayed under the message column, along with an explanation what you will need to do to rectify the situation. Most of the time it deals with something you may need to install eg) dotnet framework or if the PC is under specification.

(fig 5)

Registration information

You need to enter the clients firm name in here

The advanced option allows one to specify named instances, but this is best left hidden as it is an advanced option.

(fig 6)

Client components are disabled by default – enable them for workstations to connect

(fig 7)

Mixed mode must be enabled with a password of password123

(fig 8)

Just click next

By default the first option is enabled and both options deal with user and admin privileges.

(fig 9 )

Just click next

This is optional as it sends Microsoft information on error and usage stats.

(fig 10)

Click the install button

(fig 11)

Everything needs to be passed here, if some are not passed, you will need to refer to the setup logs found in the LOG folder of the Sql install directory.

(fig 12)

Click finish

Sql server is now installed but there are a few configuration tweaks that need to take place.

Step 2: Sql configuration Manager

You will need to click on the start button / all programs / Microsoft Sql server 2005 /

Configuration tools / sql server configuration manager

(fig 13)

TCP is not enabled by default – enable it by right clicking tcp and choosing enable

(fig 14)

(fig 15)

Step 3: Sql Server Browser

The next thing to do is to enable the sql server browser, it is not enabled by default – so you need to right click it and choose properties

(fig 16)

The start mode needs to be automatic

You must then start the sql browser and lastly, YOU MUST RESTART THE SQL SERVER !!!

Step 4: Windows Firewall

The SERVERS firewall needs to be configured. Navigate to the control panel / windows firewall

(fig 17)

Click on the add program button and navigate to:

Program files/Microsoft sql server/mssql.1/mssql/binn

Highlight sqlsrvr.exe and choose open

(fig 18)

Add two sql port numbers by clicking on the add port button

(fig 19)

Add a name of sql with port number 1433 for tcp

And sql1 with port number 1434 for udp

(fig 20)

With this done, sqlexpress should work fine, if not click start / run and type in CLICONFG

Step 5: Sql server Client Network Utility

(fig 21)

Highlight named pipes and click enable

Highlight TCP and click enable.

Conclusion:

In conclusion, this version of Sql Server is stable but with limitations. It requires a little more configuration than MSDE, but once this is done correctly, it runs smoothly.

This version can also work well with Sql Management Studio Express which is a graphical user interface much like Enterprise Manager.