April 18, 2007 at 3:10 am
Hi, first post here, so I really hope I can get some help.....
I have two untrusted domains. ASP.NET webpage server in one domain, SQL 2000 server in second domain. Trying to populate the ASP.NET webpage in domain one with data from SQL DB in domain two.
Details: ASP.NET v2, SQL2000. Can telnet from domain one to domain two on port 1433.
The error I'm getting is:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
ASP.NET webpage is running as a domain admin account, a mirrored user & password has been setup in domain two (although I think it might have to be a local ccount account, rather than a domain account).
e.g. DOMAINONE\fixmon-g and DOMAINTWO\fixmon-g both created with matching passwords.
I've tried impersonating, change the ASP worker account. Nothing seems to work.
Any suggestions will be appreciated?
thanks
April 19, 2007 at 4:32 pm
Are the logins on both SQL Server and using SQL Server Authentication?
From the looks of the examples you gave, those aren't SQL Server logins.
Windows Authentication can ONLY be used with trusted domains.
-SQLBill
April 20, 2007 at 7:42 am
Need to make sure the connection string specifies Trusted Connection = False and provide the needed SQL login credentials. Having same username/password trick really only works from machines in a workgroup on the same physical lan.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply