Using the Enterprise Manager with SQL Server

Setup and Intructions

Customers using SQL Server as their back-end database will need to use the "Enterprise Manager" provided by Microsoft for managing your database. The Enterprise Manager is a Database management tool that is comes with Microsoft SQL Server. If you do not own a copy of Microsoft SQL Server, you can download the their 30 day SQL Server evaluation software. You can download this evaluation package from Microsoft's site, and even after it expires, the Enterprise Manager remains on your computer for you to use. FYI, SQL Server Evaluation is quite large... its about 30 MB's. For more information on SQL Server visit Microsoft SQL. You can download the SQL Server evaluation at Here.

Here is the info you will need to connect to SQL server and manage your database remotely using your SQL Server Enterprise Manager:

Version: Microsoft SQL Server 7.0
Server name: server_name (assigned by us)
IP Address: xxx.xxx.xxx.xxx (assigned by us)
Database Name: Your_db (assigned by us)
Login Name : your_userid (assigned by us)
Password : your_password (assigned by us)

Instructions:

1. From the Program menu>Sql Server 7.0>Client Network Utility.
2. General Tab, Select TCP/IP from the Default Network Libarary drop down box.
3. Click ADD. Enter in Server Alias box the Server Name assigned by us ( example spider6 ).
4. Enter in Computer Name box the Server IP address assigned by us ( example 209.85.89.20)
5. Click OK.
--- Connecting with Enterprise Manager ----
1. Go into the program 'SQL Server Enterprise Manager'.
2. Click on 'Action' dropdown menu.
3. Click on 'New SQL Server Registration.
4. Type in the name of the server 'server_name'.
5. Click 'Add' & then 'Next'.
6. The SQL Server option should be selected, 'Next'.
7. Select Login Automatically.
8. Enter your Login Info
9. Click 'Next' again.
10. Click 'Finish'.
11. You should now be able to remotely access SQL Server and manage your database.

Send mail to webmaster@spiderlink.com with questions or comments about this web site.
Copyright © 1996-1997 Spiderlink Web Services

Back to Spiderlink Web Services Home Page