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 if the mirror fails over then we will lose access since the master does not get mirrored.
Is there a way of logining 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 grreatly apperiated
Hi,
Stored credentials can be found navigating to the to the Control Panel > User Accounts > Choose the User > manage you network accounts. You might have a fixed stored credential enetered there ?
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment