Hi

I have IIS Web server and SQL database server on my standalone PC.
When I run my ASP page, sometimes I got the error....

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'MYPC\IUSR_MYNAME'.

1. I used mix authentication for SQL database.

2. Connection string inside the APS page is ... as below
MyConn.Open "FILEDSN=C:\Program Files\Common Files\ODBC\Data Sources\ok.dsn"

3. For ok.dsn, I used default login, which is "windows NT authentication using network login id"

But I think it cannot be configuration problem because I don't get this error all the time. For the same ASP program, and same configuration, sometimes it turned out okay but sometimes I got this error.

Please help me with this...
thanks.