This page describes the methods to assign port number to a database.

Assigning a port number to a database

The objective is to avoid conflict on port number (the default port number is 1433) and enable good remote connections to SQL databases. The task should be done after a database is installed. If the connection will pass through the firewall then contact ItHelpdesk to know which port number can be assigned.

Process with SQL Server 2000

Using Server Network Utility

Start -? All programs -? Microsoft SQL Server -? Server Network Utility

In the window Server Network Utility, expand the list to select the name of the forum in which a port number must be assigned

If TCP / IP is not in the area Enabled protocols, then switch it in this area. It is possible to have both the Named Pipes (active mode by default) and TCP / IP. Select TCP / IP and click on "properties"

In the window "properties", assign a port number at least from 1450 (the default port number is 1433 but possibly already in use.

Existing port number on Support02 for SQL Server 2000

Process with SQL Server 2005

Using SQL Server Configuration Manager

Start -? All programs -? Microsoft SQL Server 2005 -? configuration tools --? SQL Server Configuration Manager

In the window, drill down SQL Server 2005 Network Configuration and select a database:


On the right panel, double-click on TCP/IP and go to tab IP Adress

Assign a value to option TCP Port.

Existing port number on Support02 for SQL Server 2005