Results 1 to 1 of 1
Jun 25, 2004, 07:15 #1
- Join Date
- Jun 2004
- 0 Post(s)
- 0 Thread(s)
I have this error...."Login failed for user"(But sometimes only)
I have IIS Web server and SQL database server on my standalone 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.
Please help me with this...