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.

Question

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.

samihcl

Old Hand

Points: 304
More actions
May 27, 2013 at 5:01 am

#277986

Dear All,
From morning onward in my sql server 2008 i am getting following error.
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
in my connection i have set unlimited connection but even though i am getting this error.
Pls suggest

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Bhaskar.Shetty Hall of Fame Points: 3054 More actions · Answer 1

This is because your connection pools are overfilled or some of the connection not closed properly which is not in use, try killing the unwanted connection using SSMS.

samihcl Old Hand Points: 304 More actions · Answer 2

Thanks for your immediate reply.

Can you elobrate how to do this?? as i told you i given unlimited connection..even though i am getting this issue.

Is this problem related with front end application?? or database??

Pls elobrate your slution so it will beneficial to me .

Regards,

SQL Show SSCertifiable Points: 6143 More actions · Answer 3

Are you using "Max Pool Size " setting in sql connection?

http://blogs.msdn.com/b/tolong/archive/2006/11/21/max-pool-size-was-reached.aspx