How to set up Microsoft SQL 2000 Client Network Utility

In the General information tab Enable TCP/IP and move to the top of the list.

You must create a Server Alias using Client Network Utility before creating your SQL Database connection.  When you open Client Network Utility, select the Alias tab, as shown below...

Press Add... and then select the TCP/IP radio button, as shown below...

Enter the name of your Database in the Server alias: text box.  Under the Connection parameters section, enter the IP Address of the server where your SQL Database is located in the Server name: text box.  Make sure you have selected the checkbox for Dynamically determine port.  See the example below for further details...

After you have done entered the appropriate information, press OK and the window should now look like this...

Press Apply, then OK, and you're now ready to setup the connection to your SQL Server Database through Enterprise Manager!