How to configure a client to use TCP/IP (Client Network Utility)

  • Article

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.