Server Registration

Mar 23, 2010 at 4:48 PM
Hi, I have the following questions: Is it possible to register Servers from different AD domains to a Central Management Server? How can I change the user name for the server to be registered? I see always the user with whom I am logged on. Thanks
Mar 24, 2010 at 8:10 PM

Hello SpeedyDBA,

The CMS requires windows authentication, which means that you will have problems if you try to register instances in untrusted domains where your account is not recognized.  Others have been able to circumvent this issue by adopting a different method of managing the instances.  Since this is a framework, you are free to adjust anything in the framework to work with your environment.  In your case, you may choose to store server names, groups, and sql authentication in a SQL Server table (please take care to encrypt and/or hash your passwords when they are stored in the table).  You will then change the functions and views that currently leverage the CMS tables and point them to your custom tables.