Mirror Connection Strings From Across A Remote Domain.

Sorry I didn't know the best forum for this question.

I have 3 SQL 2005 x64 servers on my remote domain.
10.1.10.65 is the primary
10.1.10.66 is the mirror
10.1.10.67 is the whitness.

All 3 machines run the MSSQLSERVER service as a domain admin user acount, and all of the other servies use LocalSystem.
All machines are configured to use the default instance name of MSSQLSERVER.

I have another seperate server ON THAT DOMAIN which runs IIS and ASP Classic.
I installed the SQL Native client on that machine.

Here is the ASP code:
-----------
<%
dim strConnString, objConn, rs, sql

strConnString = "Provider=SQLNCLI;Persist Security Info=False;User ID=sa;password=MyPassword;Initial Catalog=LCR;Data Source=10.1.10.65; Failover Partner=10.1.10.66"


sql = "SELECT * FROM DFW"
Set objConn = CreateObject("ADODB.Connection")
objConn.ConnectionString = strConnString
objConn.CommandTimeout = 300
objConn.Open

SET rs = Server.CreateObject("ADODB.Recordset")
rs.CursorLocation = 3
rs.Open sql, objConn

Do While Not rs.EOF
Response.Write rs(0) & "
"
rs.MoveNext
Loop



rs.close
objConn.close
set objConn = nothing
set rs = nothing
%>
--------------------------------

If I run this code on the server on the SAME domain and shutdown MSSQL services on the primary machine the Failover server starts working an serving data requests.

It I then take that code and run it from another REOMTE domain, I can connect to the primary server and get data, but when I force a failover for testing it refuses to connect the the MIRROR server.

In the error log on the primary server I see 12 errors.
There are 4 sets of the following 3 errors, as SQL will try to connect 4 times before failing.

1)
Date 4/7/2008 12:00:39 PM
Log SQL Server (Current - 4/7/2008 12:00:00 PM)
Source Logon
Message
Login succeeded for user 'sa'. Connection: non-trusted. [CLIENT: 10.1.3.79]

2)
Date 4/7/2008 12:00:39 PM
Log SQL Server (Current - 4/7/2008 12:00:00 PM)
Source Logon
Message
Error: 18456, Severity: 14, State: 16.

3)
Date 4/7/2008 12:00:39 PM
Log SQL Server (Current - 4/7/2008 12:00:00 PM)
Source Logon
Message
Login failed for user 'sa'. [CLIENT: 10.1.3.79]


Why does this work when the code runs on the LOCAL domain only when I'm connecting via SQL Security?


Thanks for any help.

John Rossitter