Questions tagged [central-management-server]

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.

Filter by
Sorted by
Tagged with
4
votes
3answers
2k views

Collect data with central management servers and keep them in local table

I have 50 servers. I manage them from a central management server on SQL Server 2014 Enterprise Edition. I don't use repository. I could open a query and get result for each one at the same time. But ...
7
votes
2answers
787 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 'domain\...
3
votes
0answers
603 views

SQL Server Management Studio creates 18456 login error using registered server group

I have been using "Local Server Groups" registration for quite a while now with SQL Server 2008 Management Studio. I have created a group with 5 registered servers. They are registered using ...