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

SQL Server Setup Help

SQL Server Setup Help

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

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.

    With TCP/IP, you can also specify the server with its IP address instead of its name.

  4. 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.