Installation Guide

Install Microsoft SQL Server 2005
June 2007 23
Configuring SQL Server Firewall Port Exceptions
Before QM is installed, you must manually add two ports to the firewall exception list
on the QM Database services server. This procedure is necessary only if the Microsoft
firewall is turned on. These ports are:
The default instance of the SQL Server Database Engine listens on TCP port 1433.
To add the ports to the firewall exceptions list:
1. On the SQL Server computer, start the Windows Firewall utility and select the
Exceptions tab.
2. Click Add Port to display the Add a Port dialog box.
Figure 1. Add a Port dialog box.
3. For the MSSQL server port named instance, enter a name describing the port,
the port number 1433, select TCP as the connection type, and then click OK.
4. Click Add Port again, and for the MSSQL server port, enter a name describing
the port, the port number 1434, select UDP as the connection type, and then
click OK.
Port Type Description
1433 TCP MSSQL server port
1434 UDP MSSQL server port