This documentation is archived and is not being maintained.

Connecting with Registered Servers and Object Explorer

Registered Servers and Object Explorer are similar to Enterprise Manager in Microsoft SQL Server 2000, but they have additional capabilities.

This tutorial uses the AdventureWorks database, which is a new and larger sample database that can demonstrate the more complex features of Microsoft SQL Server 2005. AdventureWorksDW is a related database that supports SQL Server Analysis Services. To help enhance security, by default, the sample databases are not installed. To install the sample databases, in Add or Remove Programs, select Microsoft SQL Server 2005, and then click Change to run Setup. For more information, see Installing AdventureWorks Sample Databases and Samples.

The toolbar of the Registered Servers component has buttons for the Database Engine, Analysis Services, Reporting Services, SQL Server 2005 Compact Edition, and Integration Services. You can register one or more of these server types for convenient management. Try the following exercise to register the AdventureWorks database.

  1. On the Registered Servers toolbar, click Database Engine if you have to. (It may already be selected.)

  2. Right-click Database Engine, point to New, and then click Server Registration.

  3. In the New Server Registration dialog box, in the Server name text box, type the name of your instance of SQL Server.

  4. In the Registered server name box, type AdventureWorks.

  5. On the Connection Properties tab, in the Connect to database list, select AdventureWorks, and then click Save.

The previous exercise shows a new feature of Registered Servers: the ability to organize your servers that have names of your choosing.

Like Registered Servers, Object Explorer can connect to the Database Engine, Analysis Services, Integration Services, Reporting Services, and SQL Server 2005 Compact Edition.

  1. On the toolbar of Object Explorer, click Connect for a list of possible connection types, and then select Database Engine.

  2. In the Connect to Server dialog box, in the Server name text box, type the name of your instance of SQL Server.

  3. Click Options and explore the choices.

  4. To connect to the server, click Connect. If you are already connected, this action just returns you to Object Explorer and sets the focus on that server.

    When you connect to an instance of SQL Server, Object Explorer presents information that looks and functions very much like the Console Root in SQL Server 2000 Enterprise Manager. Enhancements include greater scalability when exploring thousands of database objects. With Object Explorer you can administer SQL Server Security, SQL Server Agent, Replication, Database Mail, and Notification Services. Object Explorer can only manage some of the features of Analysis Services, Reporting Services, and SSIS. Each of those components has additional specialized tools.

  5. In Object Explorer, expand the Databases folder and select AdventureWorks.

    Notice that SQL Server Management Studio presents the system databases in a separate folder.