2

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.

3

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:

  • 1
    You can start SSMS with a different account to circumvent issues where one account has not been granted the rights to login to a SQL instance. – hot2use Dec 22 '16 at 6:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.