This section shows the options and their functions available in the Add (or Edit) Network Library Configuration dialog box for TCP/IP.
Option | Description |
---|---|
Server alias |
Specify a unique name for the server running an instance of Microsoft SQL Server that listens on the TCP/IP Sockets network library. |
Network libraries |
Specify the network library that will be used to connect to the server. TCP/IP is selected. |
Server name |
Specify the instance of SQL Server that listens for TCP/IP Sockets clients. |
Dynamically determine port |
Specify that the Net-Library will determine the port dynamically. The port specified in Port number will not be used. |
Port number |
Specify the port that the TCP/IP Net-library will use to attempt to connect to the target instance of SQL Server. The default is 1433, the port number Windows Sockets Net-Library generally uses for SQL Server. In most cases, use the default port number. This field is only active when the Dynamically determine port check box is cleared. |