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. AdventureWorksDW is a related database that supports SQL Server Analysis Services. To help enhance security, by default, the sample databases are not installed. For more information, see Considerations for Installing SQL Server Samples and Sample Databases.

The toolbar of the Registered Servers component has buttons for the Database Engine, Analysis Services, Reporting Services, SQL Server Compact 3.5 SP1, 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.

To register the AdventureWorks database

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

  2. Expand Database Engine.

  3. Right-click Local Server Groups, and then click New Server Registration.

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

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

  6. On the Connection Properties tab, in the Connect to database list, select <Browse server…>.

  7. In the Browse for Databases dialog box, click Yes.

  8. In the Browse Server for Database dialog box, select AdventureWorks, and then click OK.

  9. In the New Server Registration dialog box, click Save.

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

To connect with Object Explorer

  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, and Database Mail. 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.

Community Additions