Connecting to a Server
After you open the SQL Server Enterprise Manager and start SQL Server, perform the following to connect to a server.
1. |
Click the plus (+) sign next to the Microsoft SQL Servers folder.
|
2. |
Click the plus (+) sign next to the group that contains the registered server you want to connect with (usually this is the SQL Server Group).
|
3. |
Click the plus (+) sign next to the server name.
|
If a connection is successfully made, server folders will appear below the server name (see Figure 6.11).
Figure 6.11. A successful server connection.
NOTE
If you are unable to establish a connection to SQL Server from the SQL Server Enterprise ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
