Getting SQL 8.0 Connected
(Windows only)

This document provides connection instructions for SQL 8.0 users (SQL 2000). The instructions are written for accounts hosted on the Windows platform.

Before starting, you will need:

• Your SQL server name and/or your web site's IP address: These are required for your connection. If you are not sure of your SQL server's name and IP address, go to your Control Panel. For example, http://forexample-domain.com/stats. There, you will find the name of the SQL Server: server.mssqlservers.com.
• SQL Server 2000 Server Enterprise Manager: If it is not installed, you will need to run SQL Server 2000 setup from your SQL software and then select, at minimum, the Client Connectivity and Management Tools options.
  
  Tip: For your convenience, we have provided a table at the end of this document that highlights what you will need to use with regard to your SQL server location, your username, your password, and your database name.
  
  Note: SQL Server Enterprise Manager is a 32-bit application. It cannot be installed on computers running 16-bit operating systems.

SQL Server Client Network Utility

The SQL Server Client Network Utility is used for managing the client configuration for DB-Library, Net-Libraries, and custom-defined network connections.

Connecting to Your SQL Server Database

Follow these steps to establish a connection between your client computer and your SQL server database:

1.  In the SQL Server Client Network Utility, click the following sequence:

Start > Programs > MS SQL Servers > Client Network Utility > Alias tab

2.  Click Add.

3. In the Edit Network Library Configuration dialog box, type a Server alias. The alias can be any descriptive name.  

4. In the Network libraries group, select TCP/IP.

5. In the Connection Parameters group, enter your SQL server's Server name. The Server name can consist of either the SQL Server domain or the server's IP address. 

Note: Your SQL Server name is provided in your activation notice (the notice that was sent to you by way of e-mail when you opened your account) and it is also located in your Control Panel under the heading of SQL Server. For example:

server.mssqlservers.com

6. In the Port number dialog box, enter 1433. This is the standard port number for Microsoft SQL server.

7. Click OK.

SQL Server Enterprise Manager

SQL Server Enterprise Manager allows for easy enterprise-wide configuration and management of SQL Server and SQL Server objects. You can also use SQL Server Enterprise Manager to:

• Create SQL scripts
• Manage tables, views, stored procedures, triggers, indexes, rules, defaults, and user-defined data types
• Import and export data
• Transform data

By default, SQL Server Enterprise Manager is installed by SQL Server Setup as part of the server software on computers running Microsoft Windows® and as part of the client software on computers running Windows and Microsoft Windows® XP.

Using SQL Server Enterprise Manager to Register Your SQL Server

To register to your SQL server through Microsoft's SQL Server Enterprise Manager, follow these steps:

1.  Right-click the SQL Server Group. A menu will appear.

2.  In the menu, click New SQL server registration. You may be presented with a Register SQL Server Wizard. If so,  Check the box that says From now on, I want to perform this task without using a wizard and click Next.

3.  Click Browse. You will be presented with the Select Server dialog box.  

4. In Select Server, select the server that you entered in SQL Server Client Network Utility section mentioned above (for example, "SQL2400")

5. Click OK. The Registered SQL Server Properties dialog box will be displayed.

6. In the Registered SQL Server Properties dialog box, make sure that:

• the server mentioned in the Server dialog box is the server alias that you specified in the SQL Server Client Network Utility section.
• SQL Authentication must be selected
• your account UserID must be in the Login Name field
• your account password must be in the Password field. 

Realize that:

• the Server Group option is a user preference. You would use the Server Group option if you have multiple servers configured in your client and if you would like to keep them organized by groups.
• the "SQL Server Group" is the default group created when you install Enterprise Manager. 
• The bottom three checkboxes are user preferences. As such, they are optional. The third checkbox, Automatically Start SQL When Connecting, is irrelevant as only system administrators and not end users have the permissions to start the server. The recommended setup is to have all three items in the Options section unchecked.

7. Click OK.

-- Values for the SQL Server Client Utility --

The following table shows the values that you need to use when configuring the server as per the instructions in the above-mentioned SQL Server Client Network Utility section.  Note that server represents the physical server number you are on.  For Example:

Grp1
sql100.mssqlservers.com (i.e. w3w010xx, w2k1xx)

Grp14
sql1400.mssqlservers.com (i.e. w3w140xx, w2k14xx)

Grp19
sql1900.mssqlservers.com (i.e. w3w190xx, wk219xx)