patternsqlMinor
Can I use SQL Server Authentication for Central Management Servers?
Viewed 0 times
canserverssqlcentralauthenticationmanagementforserveruse
Problem
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.
This option does exist when connecting to a local server group.
Solution
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.
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.
Context
StackExchange Database Administrators Q#156776, answer score: 4
Revisions (0)
No revisions yet.