SQL 2012 Central Management Servers

I am trying to register some of my SQL servers which are in the DMZ using SQL authentication but the authentication window is grayed out.  Is it possible to register a SQL server using SQL authentication instead of windows authentication for CMS?
RayManAaaAsked:
Who is Participating?
 
Anthony PerkinsCommented:
Ah, I misunderstood.  When using  Central Management Servers you can only register servers using Windows Authentication.
0
 
Anthony PerkinsCommented:
Is it possible to register a SQL server using SQL authentication instead of windows authentication for CMS?
My guess is that the server is setup to only accept Windows Authentication and not mixed mode.  But that is pretty easy to confirm, just look at the properties for the SQL Server using SSMS.
0
 
RayManAaaAuthor Commented:
Hi,

All of my SQL servers are setup for mixed mode.  

One more thing that I should point out, this is only happening when I register a SQL server via CMS (Central Management Servers) in the registered servers view.  This is not happening when I connect to a server via object explorer.  When I connect via object explorer I have the option to connect using SQL or Windows authentication.

But in the registered view I only have one option which is windows authentication.  This to me is very strange, because if I select the same server in object explorer I can login using SQL or windows authentication.  However if I try to register the same server using CMS in the register servers view I only have one option, windows authentication.

Does this make any sense to you?
0
 
RayManAaaAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.