SQL Server Central Management Server is a feature that allows an instance of SQL Server that is designated as a Central Management Server to maintain server groups containing the connection information for one or more instances of SQL Server.

learn more… | top users | synonyms

0
votes
3answers
81 views

SQL Server Facets: “Linked Server” exist but “Registered Server” doesn't - why?

I'd like to monitor multiple SQL Server instances. Something similar to what is described in "Monitor Your SQL Server Linked Server Configurations with Policy Based Management" but instead of using ...
3
votes
2answers
248 views

What's the point in SQL Server Central Management Server?

Online MSDN article "Execute Statements Against Multiple Servers Simultaneously (SQL Server Management Studio)" (SQL Server 2012) states: "Note Before you execute the following procedures, ...
3
votes
0answers
201 views

Login failure error log when querying Central Management Server group

I am querying a group under a Central Management Server, which results in the following being logged to the SQL Server Error Log. Error: 18456, Severity: 14, State: 38. Login failed for user ...
1
vote
1answer
299 views

Execute Stored Procedure against CMS from within a SQL Server Agent job

Is it possible to execute a stored procedure (or any T-SQL) against a Central Management Server (CMS) via a SQL Agent job? The idea here is to exercise the CMS to hit all the registered instances ...