i have an asp.net application running on "aspnetserver" (win2000 adv server) under the profile "artscar" which is a local administratoraccount on "aspnetserver".

My sql database i'd like to connect to is on "sqlserver".

I have a working system DSN on "aspnetserver" pointing to the correct database on "sqlserver"


i try to connect with:
Code:
dim con as odbcconnection
dim cmd as odbccommand
dim constring as string = "DSN=MYDSN"
con = new Microsoft.Data.Odbc.Odbcconnection(constring)
con.open
cmd = new odbccommand("select......................", con) <------error occurs here
i get error 28000 :Login failed for user '(null)'.Reason:Not Associated with a trusted SQL Server connection.

i tried adding iusr_aspnetserver to the users on "sqlserver" and in sqlserver itself. iis is set up for anonymous access + integrated windows identification...

The debugging crashes at con.open, and i'm really lost at what to look for