To configure a client to use TCP/IP:

  1. Click the General tab, and then click Add.
  2. In the Add Network Library Configuration dialog box, click TCP/IP.
  3. In the Server alias box, enter the alias of the instance of Microsoft SQL Server listening on the Windows Sockets Net-Library.
  4. With TCP/IP, you can also specify the server with its IP address instead of its name.
  5. Do one of the following:
    • Select the Dynamically determine port check box to automatically determine the port.
    • Clear the Dynamically determine port check box to set the port manually, and then in the Port number box, type the port number.

For more information about other TCP/IP protocols that support Windows Sockets, see the TCP/IP documentation.

Table Of Contents