Hi,
The website I am working on is built with ASP.NET and connects to a
SQL Server 2000 database. The web server and database are on the same
machine. I have recently tried to modify the timeout of the website
from 20 mn to 60 mn. I changed the timeout setting in IIS. Now the
website itself doesn't time out, however after 20 mn, when I try to
access a page that needs to connect to the database, I get the
following error message
************************************************** ****************************************
Form Request:
ASP Code:
Error Number: -2147217843
ASP Source:
Error Category: Microsoft OLE DB Provider for SQL Server
File: /emissionsestimation/includes/db.asp
Line: 13
Description: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
ASP Description:
Date: 1/13/2004 9:26:08 AM
************************************************** ******************************************
If I access a page that doesn't connect to the database, it works
fine.
My connection string to the database is:
"PROVIDER=SQLOLEDB;Data Source=*IP_ADRESS*;User
Id=*USER_ID*;Password=*PASSWORD*;Initial
Catalog=EmissionEstimations;Trusted_Connection=yes ;"
The connection to the database works fine unless the website is idle
for 20 mn. After 60 mn, I get the time out message I expected. So the
"login failed for user" message only happens if the application is
left idle between 20 mn and 60 mn.
Maybe the database has some kind of timeout setting that needs to be
modified as well? However why the "login failed" message ? Why this
user "ANONYMOUS" ? I'm kinda confused and I'd appreciate some help
onto why this happens and what to do about it.
Thanks heaps
Maelle