
September 18th, 2006, 12:44 AM
|
|
Registered User
|
|
Join Date: Sep 2006
Posts: 1
Time spent in forums: 2 m 8 sec
Reputation Power: 0
|
|
|
SQL 2005 Authentication
We have a sql 2005 server mirror set that we need to connect to.
I am in one active directory domain (eg DomainA) and the sql 2005 mirror is in another (eg DomainB).
We are not allowed (by the sql 2005 server provider) to put a trust between the two active directory domains and if we use a sql server login then when the mirror fails over then we lose access since the master does not get mirrored.
Is there a way of logining EnterpriseManager/QueryAnalyser in to the sql server 2005 mirror in DomainB with out logging my whole machine into DomainB or is there a way to mirror the sql users between the two sql 2005 mirror servers.
Any help would be greatly apperiated
|