RayManAaa
asked on
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?
ASKER
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
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.