How to connect to MS SQL Server Database using Enterprise Ma

[Shane Melson]

In order to use MS Sql Server Enterprise Manager to connect to your Hosts Station 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.


Let's Start by following these steps.......

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 - eSupportHost (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 "eSupportHost" 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.

At this point you should be connected to your database with Enterprise Manager.If for some reason you're not, repeat the steps above and double check your work.
If you have performed all of the above and still can't connect, I will suggest you to please contact your favourite SENIOR WINDOWS EXPERTS.....