I'm trying to slove this problem from last few hours. I cannot slove this problem. so i have come to you guys.
this is the error that i get:
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
I have a IIS(5) running on computer A(windows 2000 server) and SQL Server (2000) running on computer B(windows xp). I'm trying to connect to SQL server using DSN created into IIS computer, A. I'm using ASP code. I have tried troubleshooting by giving user id, and password to DSN. but still no luck. I have SQL Server set to SQL server and Windows authentication.