Forms Authentication & ASP.NET Membership Session Timeout

Question

I have a website which has Forms Authentication and ASP.NET Membership is used in it. At some pages Transactions (System.Transactions) are used too.
After deploying it to the server, the session timeout issue is creating a mess, and few E-mail relays and DB operations are unable to be executed.
I want to know how can I fix this issue. If additional information is needed I can provide.

I have looked into too many blogs and forums, but could not find the solution or the correct/single solution.
Following error is shown sometimes:- Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool.

And the application is deployed on Windows 2008 R2 Server with IIS 7.5.
Looking forward for quick response.

The error message makes me believe the timeout has to do with a database connection. That means it has nothing to do with Forms Authentication. But without more information, it's difficult to help. Could you post the code that is throwing the exception at least? — Jeff Siver

Dave Hogan Dave Hogan · Accepted Answer · 2012-10-16T18:00:33

Sounds like you're not closing your DB connections correctly.

Make sure any place you open a SQL connection that you're closing it. Ideally wrap them in using blocks.

Post up some some of your typical DB code and I'll review it.

Forms Authentication & ASP.NET Membership Session Timeout

1 Answers