Time Out Problem Of Sqlcoonnection Pool

Question

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

Khan Abrar Ahmed · Answer

Add the connection timeout in your connection string or add the timeout when you are creating the connection object. Connect Timeout=1000

Karthikeyan K · Answer

Hi sir, Refer the link sir it may solve your problem 1.http://www.codeproject.com/Questions/423588/The-timeout-period-elapsed-prior-to-obtaining-a-co If it is useful then accept my answer

Manas Mohapatra · Answer

1. Increase Max Pool Size in connection string connectionStrings > add name = " sqlConnectionString " connectionString = " Data Source=mySQLServer;Initial Catalog=myDatabase;Integrated Security=True;Connection Timeout=15;Connection Lifetime=0; Min Pool Size=0;Max Pool Size=500;Pooling=true; " /> connectionStrings > 2. Make sure that you are closing/disposing Database connection object so that it will go to connection pool for next database call.

Rajeesh Menoth · Answer

Hi, //This may have occurred because all pooled connections were in use and max pool size was reached. Set in Max Pool Size=500 or above; Eg : add name = " DbCon " connectionString =" Data Source=.;Initial Catalog=ShaShib;Integrated Security=True;pooling='true'; Max Pool Size=6000; " /> Ref : https://rajeeshmenoth.wordpress.com/2014/06/10/timeout-expired-and-the-timeout-period-elapsed-prior-to-obtaining-a-connection-from-the-pool/

Ravi Kumar · Answer

hi your running application from IIS right then there go to advanced setting and give the physical crydentials

Time Out Problem Of Sqlcoonnection Pool

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

Answers (5)