Sql-server – use SQL Server Authentication for Central Management Servers

central-management-serversql serverssms

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: