![]() ![]() You must use Windows Authentication for the central management server. In the New Server Registration dialog box, select the instance of SQL Server that you want to become the central management server from the drop-down list of servers. In Registered Servers, expand Database Engine, right-click Central Management Servers, and then click Register Central Management Server. In SQL Server Management Studio, on the View menu, click Registered Servers. The following procedures describe how to perform the following steps.Īdd one or more server groups to the central management server and add one or more registered servers to the server groups. For example, the user might be a member of the sysadmin fixed server role on the instance of SQL Server A, but have limited permissions on the instance of SQL Server B. Membership in the ServerGroupReaderRole role is required to connect to a central management server.īecause the connections that are maintained by a central management server execute in the context of the user, by using Windows Authentication, the effective permissions on the registered servers might vary. Only members of the ServerGroupAdministratorRole role can manage the central management server. Two database roles in the msdb database grant access to central management servers. To create a Central Management Server and Server Group, using: Versions of SQL Server that are earlier than SQL Server 2008 (10.0.x) cannot be designated as a central management server. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |