Solved

SQL 2012 Central Management Servers

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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Query Optimization 14 42
Help Required 3 93
convert null in sql server 12 32
MSSQL Import .SQL files - Increase Import Speed 9 32
When you upgrade from Windows 8 to 8.1 or to Windows 10 or if you are like me you are on the Insider Program you may find yourself with many 450MB recovery partitions.  With a traditional disk that may not be a problem but with relatively smaller SS…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
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…

776 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