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; Grant
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 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 comments:
Post a Comment