Purpose

The purpose of this article is to teach you the process of configuring a client to use TCP/IP using Client Network Utility in Microsoft SQL Server 2000.

To Configure a Client to Use TCP/IP

Client applications can connect to Microsoft SQL Server using the TCP/IP. The protocols are implemented using a client network library contained in the SQL Native Client dll. TCP/IP is a common protocol widely used over the Internet. It includes standards for routing network traffic and offers advanced security features. Configuring your computer to use TCP/IP can be complex, but most networked computers are already properly configured.

Following steps describe you the step by step details of configuring a client to use TCP/IP:

1. Click Start, go to Programs, then go to Microsoft SQL Server, and then click Client Network Utility.

2. Select Alias tab.

3. Click Add button, now select TCP/IP under Network libraries, and alias server against Server alias, and either select Dynamically determine port option or give a port number for Port number option.

4. Now, click OK.

5. Click Apply, and then click OK.