Adding servers to CMS from mutiple window domains requiring different ID's

  • Our SQL Administration unit manages SQL Servers for multiple windows domains. We have a central "management" domain which trusts all other windows domains, however, not all the other windows domains trust our management domain.

    I can connect to all SQL Servers in all domains in SSMS using the SA account and password for that particular server in that domain...with hundreds of servers, this is not very conducive to efficient administration.

    When I try to register a server in CMS, I am only offered a option to add a server using the current credentials I am logged into SSMS with, I can't add a server using SQL Server authentication or credentials from another domain that the server is in.

    My question - is it even possible to add servers from other domains using credentials other than the credentials used to connect to the CMS?

    I have a PowerShell script which can automate the entire registration process for all servers in all domains, but I can't seem to change connection credentials when registering. Is it possible?

    An example, if I made this clear as mud: CENT is the domain which trusts all other domains. SQL1 is our CMS server in the CENT domain and CENT\Admin is the administrator account that I connect to CMS with.

    I am able to connect to the server SQL2 in the EXT domain (EXT\SQL2) using the SA account and password from SSMS located on CENT\SQL1.

    But I can't register EXT\SQL2 in CMS on CENT\SQL1 using credentials other than CENT\Admin...which will not connect once the server is registered because CENT\Admin is not a trusted account in the EXT domain.

    Sorry if this is still clear as mud. Let me know if there is something else I can explain better.

    Thank you.

    JK

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply