HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Can I use SQL Server Authentication for Central Management Servers?

Submitted by: @import:stackexchange-dba··
0
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.

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.

Context

StackExchange Database Administrators Q#156776, answer score: 4

Revisions (0)

No revisions yet.