background image

270

Appendix A

Once you have the prerequisites installed, run the SQL Express installer 

and select all the defaults except for Authentication Mode. Select 

Mixed Mode

set a 

sa

 login password of 

password1

, and then continue with the installation.

With the basic installation of SQL Server complete, you need to make a 

few more changes to make it accessible on your network:

1.

Select 

Start

All Programs

Microsoft SQL Server 2005

Configuration 

Tools

, and then select 

SQL Server Configuration Manager

.

2.

When the Configuration Manager starts, select 

SQL Server 2005 Services

right-click 

SQL Server (SQLEXPRESS)

, and select 

Stop

.

3.

Expand SQL Server 2005 Network Configuration Manager and select 

Protocols for SQLEXPRESS

, as shown in Figure A-1.

Figure A-1: Protocols for SQLEXPRESS

4.

Double-click 

TCP/IP

, and on the Protocol tab, set 

Enabled

 to 

Yes

 and 

Listen All

 to 

No

.

5.

Next, while still within the TCP/IP Properties dialog, select the IP Addresses 
tab and remove any entries under IPAll. Under IP1 and IP2, remove the 
values for TCP Dynamic Ports and set 

Active

 and 

Enabled

 for each of 

them to 

Yes

.

6.

Finally, set the IP1 IP Address to match your static IP address set earlier, 
set the IP2 address to 

127.0.0.1

, and set the TCP port for each of them 

to 

1433

. Your settings should look similar to those shown in Figure A-2. 

Click 

OK

 when you are all set.

Next, you’ll need to enable the SQL Server Browser service:

1.

Select 

SQL Server 2005 Services

 and double-click 

SQL Server Browser

.

2.

On the Service tab, set the 

Start Mode

 to 

Automatic

.