SQL Database Connection

Click here for information on how to use Microsoft Access to connect to a database on Temple's Network.

NOTE: If you do not have a licence for SQl Enterprise Manager visit Computer Business Services web site for purchasing information.
(Software Name: SQL Server 2000 Developer's Edition)

To make a connection to the database using SQL Server Enterprise Manager perform the following tasks.

1.
Open Enterprise Manager from
Start --> All Programs --> Microsoft SQL Server --> Enterprise Manager.

2.
Click on the + sign next to Microsoft SQL Servers

3.
Right click on SQL Server Group and select " New SQL Server Registration "

4.
Click " Next" on the Welcome screen

5.
Type" dbserver.temple.edu " under Available servers and then click Add . The name of the server should now be under Added Servers.

6.
Click Next

7.
Under "Select an Authentication Mode" dialog mode select the second radio button "The SQL Server login.."

8.
Click Next

9.
Enter user login name and password which was provided to you by the database administrator.

10.
Click Next

11.
Under the Select SQL Server Group dialog box you can either make a new group or use the default group. If you plan to use the default group click next or enter the new group name and then click next.
(It is recommended to make a new group if you are managing multiple database on the DBSERVER)

12.
Click Finish

13.
Click Close

14.
Your new database connection should now be under the group name you selected in Step 11 on the left hand panel.

15.
Click on the + sign next to your group name or SQL Server Group if you selected the default settings in step 11

16.
Click on the + sign next to DBSERVER.TEMPLE.EDU

17.
Click on the + sign next to DATABASES

18.
Click on the + sign next to your database

19.
You can now view all the elements that are associated with your database.

NOTE: You will be able to view other databases on the server but will not be able to view their content or have access to data not associated with your database.