Can I use SQL Server Authentication for Central Management Servers?

Question

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.

Answer 1

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.