[eUKhost.com]

In order to use MS SQL Server Enterprise Manager to connect to your ms SQL Server Database you will first need to establish a connection using the MS Client Network Utility which was also installed when you installed Enterprise Manager on your local machine.

Follow the steps given below to establish the connection :-

1. Open the SQL Server Client Network Utility (Start -> Programs -> Microsoft SQL Server -> Client Network Utility)
2. Click on the "Alias" tab.
3. Click "Add" and enter the following information:
1. Server Alias - eUKSupportHost (This is an example)
2. Network Library - TCP/IP
3. Computer Name - Put_IP_Address_Here.
4. Port Number - 1533 (Or else the port number which is in use)
4. Click OK.
5. Click OK again - This will close out your Client Network Utility session.
6. Open Enterprise Manager.
7. Right Click "Microsoft SQL Servers" and select "New SQL Server Registration" This will open a wizard.
8. Click Next.
9. Select "eUKSupportHost" from the list of available servers and "Add" it.
10. Click Next.
11. Choose to connect using SQL Server Authentication.
12. Enter your assigned SQL Server username and password.
13. Keep clicking next until the wizard is completed.