3

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.

Paul White ♦
95.3k30 gold badges439 silver badges689 bronze badges
asked Nov 30, 2016 at 14:15

1 Answer 1

4

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:

Paul White ♦
95.3k30 gold badges439 silver badges689 bronze badges
answered Nov 30, 2016 at 14:32
1
  • 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. Commented Dec 22, 2016 at 6:15

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.