Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SQL 2012 Central Management Servers

Posted on 2014-01-21
4
Medium Priority
?
367 Views
Last Modified: 2014-01-27
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?
0
Comment
Question by:RayManAaa
  • 2
  • 2
4 Comments
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 39798777
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
 

Author Comment

by:RayManAaa
ID: 39799706
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
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 2000 total points
ID: 39801691
Ah, I misunderstood.  When using  Central Management Servers you can only register servers using Windows Authentication.
0
 

Author Closing Comment

by:RayManAaa
ID: 39811825
Thanks
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Ready to get certified? Check out some courses that help you prepare for third-party exams.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question