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
SQl Server Database 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
SQl Server Database 2005