Thursday, March 29, 2012

Do mirrored servers have to be in same domain?

hi,
Can someone tell me if servers participating in SQL 2005 database mirroring
have to be in the same domain or can they just be stand alone servers? I
can't seem to find any documentation about this.
Thanks.No.
In case if the domain account for any of the server is different for example
the domain account for mirror server is different than the domain account of
the principal or the witness server then you can use the following statement
to grant permissions to the endpoint to that domain account: (You will need
to run the below statement on all the three participating servers)
Use Master; Create Login [Domain\Domain_user_account] From Windows; Gran
t
Connect on EndPoint ::Mirroring_Endpoint to [Domain\Domain_user_account]
;
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and
time
asking back if its 2000 or 2005]
"Steve" wrote:

> hi,
> Can someone tell me if servers participating in SQL 2005 database mirrorin
g
> have to be in the same domain or can they just be stand alone servers? I
> can't seem to find any documentation about this.
> Thanks.
>

No comments:

Post a Comment