Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQL 2012 Central Management Servers

Posted on 2014-01-21
4
Medium Priority
?
363 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

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.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

661 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