EnterpriseManager/SQL Query Analysier (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 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

Enterprise Manager Showing Wrong Authentication Mechanism

This is strange,
SQL Authentication is set to mixed mode on an SQL 2000 Server but if I TS
into the server or I look on the console locally, it shows it as only being
Windows Authentication...
Anyone know of this bug? And how to fix?How do you know it's set to mixed mode? Did you try logging
in with a SQL login?
If you are just looking at a registry setting, it's possible
the service was not restarted to allow the server to be set
to mixed mode.
-Sue
On Tue, 13 Sep 2005 14:38:59 -0700, "Chuck"
<Chuck@.discussions.microsoft.com> wrote:

>This is strange,
>SQL Authentication is set to mixed mode on an SQL 2000 Server but if I TS
>into the server or I look on the console locally, it shows it as only being
>Windows Authentication...
>Anyone know of this bug? And how to fix?|||Yes, I am currently logging in as an SQL login account. This client of mine
does not use Windows authentication...
"Sue Hoegemeier" wrote:

> How do you know it's set to mixed mode? Did you try logging
> in with a SQL login?
> If you are just looking at a registry setting, it's possible
> the service was not restarted to allow the server to be set
> to mixed mode.
> -Sue
> On Tue, 13 Sep 2005 14:38:59 -0700, "Chuck"
> <Chuck@.discussions.microsoft.com> wrote:
>
>|||_-=?/today_-=?/354
"Chuck" wrote:

> This is strange,
> SQL Authentication is set to mixed mode on an SQL 2000 Server but if I TS
> into the server or I look on the console locally, it shows it as only bein
g
> Windows Authentication...
> Anyone know of this bug? And how to fix?|||_-=?/today_-=?/354
"Chuck" wrote:
[vbcol=seagreen]
> Yes, I am currently logging in as an SQL login account. This client of mi
ne
> does not use Windows authentication...
> "Sue Hoegemeier" wrote:
>