I have set up a Central Management Server in SQL Server. When I try to add a new Registered Server to this Central Management Server, I only have the options to use Windows Authentication or Active Directory Integrated Authentication. Is there a way to connect to these Registered Servers using Sql Server Authentication?
This option does exist when connecting to a local server group.
Best Answer
CMS Drawback: Windows Authentication Only, And Only Your Login
Central Management Servers and subordinate registered servers can be registered only by using Windows Authentication.
See:
Create a New Registered Server (SQL Server Management Studio) in the documentation
Central Management Server (CMS) – A Hidden Gem by Dan Taylor.