SQL Database Connection
Click here for information on how to use Microsoft Access to connect to a database on Temple's Network.
To make a connection to the database using SQL Server Enterprise Manager perform the following tasks.
Open Enterprise Manager from
Start --> All Programs --> Microsoft SQL Server --> Enterprise Manager.
Click on the + sign next to Microsoft SQL Servers
Right click on SQL Server Group and select " New SQL Server Registration "
Click " Next" on the Welcome screen
Type" dbserver.temple.edu " under Available servers and then click Add . The name of the server should now be under Added Servers.
Under "Select an Authentication Mode" dialog mode select the second radio button "The SQL Server login.."
Enter user login name and password which was provided to you by the database administrator.
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)
Your new database connection should now be under the group name you selected in Step 11 on the left hand panel.
Click on the + sign next to your group name or SQL Server Group if you selected the default settings in step 11
Click on the + sign next to DBSERVER.TEMPLE.EDU
Click on the + sign next to DATABASES
Click on the + sign next to your database
You can now view all the elements that are associated with your database.