Connection Pool Timeout Issues
Posted on 2012-09-14
I'm having some trouble with an ASP.NET app and my programmer is on vacation. Yay!
I've got the app running on a number of different servers without issue but this specific instance is on a very locked down Windows 2008 Server Standard edition VM. I have been granted local admin rights and I have a Windows SQL Server 2008 Enterprise R2 installation (which I upgraded from SQL Server 2008 Enterprise). I can access the database from SSMS and query data in the tables logged in as SA so everything seems to be working correctly as far as that goes but I'm having trouble from the application.
My connection string is as follows:
connectionString="Data Source=localhost\MSSQLSERVER;Initial Catalog=MYDB;Connection Timeout=0;Persist Security Info=True;User ID=sa;Password=mypassword"
I'm getting the following error with the default configuration (which is working on my other servers):
"Timeout expired. The timeout period elapsed prior to connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached."
The Exception Details:
"System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached."
The Source Error comes from a line in the .vb file of the page I'm trying to load. The specific line that's highlighted is:
I think that's getting values from the database to populate a dropdown list box (not positive - again programmer is on vacation).
Any ideas what I should be looking at?