Knowledgebase

MS SQL SERVER 2000 - Connecting to a Remote SQL Server Using Enterprise Manager

Please follow the instructions below:

1) Open the SQL Server Client Network Utililty (Start -> Programs -> Microsoft SQL Server -> Client Network Utility)

2) Click on the "Alias" tab

3) Click "Add" and enter the following information:

Server Alias - MSSQL SERVER
Network Library - TCP/IP
Computer Name - 72.18.136.133
Port Number - 1533

4) Click OK

5) Click OK - This will close out the Client Network Utility

6) Open Enterprise Manager. Right Click "Microsoft SQL Servers" and select "New SQL Server Registration" This will open a wizard. Click Next.

7) Select "MSSQL SERVER" from the list of available servers and "Add" it. Click Next.

Choose to connect using SQL Server Authentication

9) Enter your assigned username and password. Keep on clicking next until the wizard is completed.

MSSQL port: 1533

For connection string refer http://www.connectionstrings.com

To

Add to Favourites

Print this Article