Microsoft SQL Server Default instance listens on TCP port 1433. Named instances of the SQL Server Database Engine and SQL Server Mobile are configured for dynamic ports, which means they select an available port when the SQL Server service is started. When connecting to a named instance through a firewall, configure the Database Engine to listen on a specific port, so that the appropriate port can be opened in the firewall.
The default SQL Server port is 1433 but only if it's a default install. Named instances get a random port number.
The browser service runs on port UDP 1434.
Reporting services is a web service - so it's port 80, or 443 if it's SSL enabled.
Analysis services is 2382 but only if it's a default install. Named instances get a random port number.
- Determine the TCP/IP port number of the instance of SQL Server.
SQL Server 2005
- Open SQL Server Configuration Manager, and then expand SQL Server 2005 Network Configuration.
- Click Protocols for InstanceName, and then double-click TCP/IP in the right panel.
Note InstanceName is a placeholder for the named instance of SQL Server 2005.
- On the Protocol tab, notice the value of the Listen All item.
- Click the IP Addresses tab:
- If the value of Listen All is yes, the TCP/IP port number for this instance of SQL Server 2005 is the value of the TCP Dynamic Ports item under IPAll.
- If the value of Listen All is no, the TCP/IP port number for this instance of SQL Server 2005 is the value of the TCP Dynamic Ports item for a specific IP address.
Note If the value of the TCP Dynamic Ports item is not set, you must set it yourself. For more information about how to configure a server to listen on a specific TCP port, visit the following Microsoft Developer Network (MSDN) Web site: http://msdn2.microsoft.com/en-us/library/ms177440.aspx (http://msdn2.microsoft.com/en-us/library/ms177440.aspx)
- Click OK.
- SQL Server 2000
- On the server that is running SQL Server 2000, start the Server Network Utility.
- Click the General tab, and then select the instance that you want from the Instances list.
- Click TCP/IP, and then click Properties. The TCP/IP port number for this instance is shown. Note this number for use later.
- Configure the server alias on the client computer.
SQL Server 2000
- Start the Client Network Utility.
- On the General tab, verify that TCP/IP appears in the list under Enabled protocols by order.
- Click the Alias tab, and then click Add.
- Under Network libraries, select TCP/IP.
- In the Server name text box, type the IP address of the server that is running SQL Server 2005.
Note The IP address that you type here is the one that is configured to use the TCP/IP port number.
- Click to clear the Dynamically determine port check box, and then type the port number of the instance of SQL Server 2005 in the Port number text box.
- Type a name in the Server alias text box, and then click OK.
|