Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 3 down vote favorite

In Domain1, I have an MSX with 75+ TSXes registered. Now I've been given some SQL Server instances in another domain. Is it possible to enlist Domain2 instances to an MSX in Domain1 ?

share|improve this question
What is the version of the master node? – Jon Seigel Jul 20 '12 at 0:31
@JonSeigel, the master node is 2008 R2 sp1; the farm has a farm of 2005, 2008, and 2008 R2 instances. – Oliver Jul 23 '12 at 19:41

1 Answer

up vote 2 down vote accepted

The answer is yes, if

  1. The two domains have sufficient trust relationships configured, or
  2. You can figure out how to set it up using pass-through authentication (I believe this requires running SQL Agent under matching accounts).

Here is the Master Server setup screen:

Master Server Wizard

In other words, there is no bypassing Windows authentication.

IMO, if there are no trusts between the domains, and there shouldn't be for business or security reasons, I think it would be a better idea to set up a new master server in the other domain, instead of circumventing security just for this.

share|improve this answer
Thanks, Jon. We do have trust between the domains (over time they'll be combined into one), and I had already been running the Agents on a common account. My network admin changed a DNS config to tell the server to check the other domain if it couldn't find it in its home domain. Now all instances of SQL Server across both domains are enlisted to a single MSX. – Oliver Jul 30 '12 at 15:23

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.