From the Start menu, select Programs, select Microsoft SQL Server 7.0, click Client Network Utility. There are really two parts to this. This first part consists of installing and configuring the SQL Server Client Network Utility on your remote computer. The second part consists of establishing a connection to your server.
a. How do I configure the SQL 7.0 Client Network Utility?
To configure the SQL 7 Client Network Utility, perform the following steps:
The following steps assume that SQL Server 7.0 Server Enterprise Manager is installed. If not, you will need to run SQL Server 7.0 setup from your SQL software and select the Client Connectivity and Management Tools options.
Remember that SQL Server Enterprise Manager is a 32-bit application. It cannot be installed on computers running 16-bit operating systems.
From the Start menu, select Programs, select Microsoft SQL Server 7.0, click Client Network Utility.
From the General tab, click Add.
In the Server alias text box, enter a name for your server.
Note: This is the server running Microsoft SQL Server that listens on the TCP/IP Sockets network library. You can name it anything you want.
From the Network libraries menu, click to select TCP/IP.
Enter your Computer name. Your Computer name is your account IP address.
No te: The Port number should always be 1433. This is the default TCP/IP port SQL listens on.
Click OK.
b. How do I establish a connection to the SQL 7.0 server?
To establish a connection to the SQL 7.0 server, perform the following steps:
Note: The following steps assume that you have already configured your SQL 7 Client Network Utility.
From the Start menu, select Programs, select Microsoft SQL Server 7.0, click Enterprise Manager.
Right-click SQL Server Group. Click New SQL Server Registration.
From the Register SQL Server Wizard, click Next.
Click to select the server you configured using the SQL 7 Client Network Utility. Click Add.
Click Next.
Click to select The SQL Server login information that was assigned to me by the system administrator. (SQL Server authentication). Click Next.
Click to select Login automatically using my SQL Server account information.
Enter your Login name and Password. Click Next.
Note: For Login name and Password, use your Control Panel User ID and Control Panel Password.
Click to select Add the SQL Server(s) to an existing SQL Server group.
From the Group name drop-down menu, ensure that SQL Server Group is selected. Click Next.
Click Close.
