Wednesday 12 January 2011

Central Management Server

This is a server which contains a central repository of sql servers which can be grouped in various ways. These could be grouped into customers, versions (2008, 2005) or state (Development, Staging, Production).

This group can be used to connect to SQL Server configuration manager, to run queries, object explorer or to evaluate policies for policy based management.

To create a central management server this can done through Registered Servers on the view menu. For more details

The Central Management Server only works in one windows domain, so if there are multiple domains that require to be managed there will need to be multiple Central Management Servers.

No comments:

Post a Comment

Note: only a member of this blog may post a comment.