We have an ASP .Net 2.0 application running on a web server (IIS 6.0, Windows Server 2003 SP2) on front end machine. This application executes a stored procedure on warehouse machine (different machine from front end machine) and shows the success/Failure message onto application.Problem: If stored proc execution time is < 5mins (approx), everything runs fine and the result gets generated.
But if stored proc execution takes longer (> 5 mins), user is prompted to provide credentials after 5 mins. And if user provides credentials, same stored proc is executed again. And again if it takes > 5 mins, user is prompted to provide credentials. This happens thrice before the process gets aborted saying that “You are not authorized to access this page”
All the timeout values in IIS settings are >5 mins. and the database command(Query) timeout is set to 30 mins.
Can any one suggest that do we have any value in Registry/IIS config files where the default timeout value is 5 mins.