Establishing Server Groups and Registering SQL Server in Enterprise Manager

As Enterprise Manager can manage multiple servers, it needs some way to connect to and organize the servers. Connecting to the server is done by registering the server. After the servers are registered, they can be organized into logical groups.

Server Groups

Server Groups in EM are used to group servers and named instances. When EM is first installed, a default group named SQL Server Group exists. Additional groups can be created to logically organize servers. For example, servers could be grouped by department or geographic location. Another good use of groups is to separate development servers from production; this reduces the risk of inadvertently making changes to ...

Get Microsoft® SQL Server™ 2000 Unleashed, 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.