Unanswered: I have this error...."Login failed for user"(But sometimes only)
I have IIS Web server and SQL database server on my PC.
When I run my ASP page, sometimes I got the error....
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.