Solved

SQL 2012 Central Management Servers

Posted on 2014-01-21
4
344 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 500 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
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…

747 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now