All,

I run DNN 3.2.2 with MS Server2000 with MS SQL 2000.  Every two weeks or so, I get an error message every once in a while called, "The timeout period elapsed prior to obtaining a connection from the pool."  I do not see the portals load up like they should.  When I restart the server, it is fine for a while, but the error message returns again within 10 - 14 days.  Below is copied directly from the server logs.

AssemblyVersion: -1
Method:
FileName:
FileLineNumber: -1
FileColumnNumber: -1
PortalID: -1
PortalName:
UserID: -1
UserName:
ActiveTabID: -1
ActiveTabName:
AbsoluteURL:
AbsoluteURLReferrer:
ExceptionGUID:
DefaultDataProvider:
InnerException: 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.
Message: 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. at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Services.Scheduling.DNNScheduling.SqlDataProvider.GetSchedule() at DotNetNuke.Services.Scheduling.DNNScheduling.SchedulingController.GetSchedule() at DotNetNuke.Services.Scheduling.DNNScheduling.CoreScheduler.LoadQueueFromTimer() at DotNetNuke.Services.Scheduling.DNNScheduling.CoreScheduler.Start()
StackTrace:
Source:
Server Name: XXXXXXXX

Is there anyone out there who has faced this problem?  If so, what step(s) did you take to resolve it?  It is hurting my business when this error message keeps popping up and is driving away potential customers.  Is there a valid solution to the problem?

Any insights or help solving this issue would be greatly appreciated!

-Eric