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 ...
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 ...