Description of Issue
Superlative Solutions provides database services to its clients utilizing Microsoft SQL Server 2000. Due to the confidential nature of the data maintained on these services, and in order to protect our client's data assets, we have modified security on our systems. This article details how to configure SQL Server Enterprise Manager and Query Analyzer so that you may gain access to the server.

Resolution
By default, SQL Server 2000 can be accessed, via TCP/IP, using the default port of 1433. Since this is a well-known service address, Superlative Solutions has modified SQL Server to use a different port. In order to access your SQL Server database(s), you will need to perform the following action:

1. Contact us to get the correct port currently in effect
2. Use the "SQL Server Client Network Utility" to create a non-standard SQL Connection configuration

This article assumes you have the Microsoft SQL Server 2000 client utilities installed on your workstation. If you do not, you may download it from Microsoft.

Creating a Connection in SQL Server Client Network Utility

Use the following procedure to create an SQL Server Alias on your Windows machine:

1. Launch the "SQL Server Client Network Utility" by click the Windows START button, then going to "Program", "Microsoft SQL Server" and clicking on the "Client Network Utility" icon. The utility will start and a dialog similar to the following will be displayed:

2. Click the second tab (Alias), circled in red above, which will display a dialog similar to the following:

3. You will see a list of currently defined SQL Server aliases (if any). If the one you need is currently defined, you'll only need to edit it by clicking on it in the list, and then clicking the "Edit..." button. If it is not in the list, you will need to add it by click the "Add..." button. In either case, a dialog similar to the following will be displayed:

4. Complete this screen according to the following:

• Server Alias: Enter your desired name for this alias, which you will use when you register the server in Enterprise Manager
• Network Libraries: Select the radio button associated with TCP/IP
• Server Name: Enter the server name (either sql01.ssiwt.com or sql02.ssiwt.com)
• Dynamically Determine Port: You must UNCHECK this box, so you can access the port number field
• Port Number: Enter the port number we have provided you when you contacted us.

5. After completing this screen, click the OK button to return to the previous dialog box. Press OK on that screen to save your changes and exit the utility.