How to configure a client to use TCP/IP (Client Network Utility)
To configure a client to use TCP/IP:
Click the General tab, and then click Add.
In the Add Network Library Configuration dialog box, click TCP/IP.
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.
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.