Live Traffic Map

Total Pageviews

Thursday, February 21, 2008

SSRS Pooled Connections Max

After adding 100+ SQL queries to a report, you may encounter the following error:

A connection cannot be made to the database. 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.
This can be fixed by changing the Pooled value of the dataset from true to false.

As long as the performance of the report is not adversly affected and only a few users will be running the report, then this should not be a problem.

0 comments:

Blog Archive