.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Post New Web Links

A connection has exceeded the idle timeout of this connection pool ????

Posted By:      Posted Date: August 29, 2010    Points: 0   Category :WCF
Dear all,I have an the following message in my service lo :A connection has exceeded the idle timeout of this connection pool <E2ETraceEvent xmlns="http://schemas.microsoft.com/2004/06/E2ETraceEvent"> <System xmlns="http://schemas.microsoft.com/2004/06/windows/eventlog/system"> <EventID>262147</EventID> <Type>3</Type> <SubType Name="Information">0</SubType> <Level>8</Level> <TimeCreated SystemTime="2009-06-12T10:11:24.7047020Z" /> <Source Name="System.ServiceModel" /> <Correlation ActivityID="{5e7a4c90-646a-41ae-8081-b6ebddbe3e9e}" /> <Execution ProcessName="Maillefer.Nomos.Plateform.Service.Console" ProcessID="5984" ThreadID="12" /> <Channel /> <Computer>VISTATEST</Computer> </System> <ApplicationData> <TraceData> <DataItem> <TraceRecord xmlns="http://schemas.microsoft.com/2004/10/E2ETraceEvent/TraceRecord" Severity="Information"> <TraceIdentifier>http://msdn.microsoft.com/fr-FR/library/System.ServiceModel.Channels.ConnectionPoolIdleTimeoutReached.aspx</TraceIdentifier> <Description>A connection has exceeded the idle timeout of this connection pool (00:02:00) and been closed.</Description> <AppDomain>Maillefe

View Complete Post

More Related Resource Links




How i can set idle timeout in SQL server 2005? In case of Oracle we can set this using profile.

But we don't know how to set in SQL server 2005/

Response from experts would highly help us to proceed our testing.


Thanks in Advance





Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This ma


Hi all,


I have one webservice . previously i had used microsoft enterprice library  then i got some tome out exception  then some of my friends told that the exception because of enterprice library . then i changed my data access layer to normal connection.

But  still i got the time out error ... also i had done some more settings


<add key="pooling" value="true" />
        <add key="Max Pool Size" value="500" />
        <add key="Min Pool Size" value="2" />

also i given the connection timeout =10.

and i cross checked the code  every ware i am closing the connection also........But still  i am getting the error as

"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"




Please help me to solve this issue...


thanks in advance.



How to impersonate a connection to SQL server under IIS app pool account if Windows Authentication i

I have a requirement I should connect to MS SQL server under IIS Application pool account from ASP.NET application where Windows Authentication is enabled. I cannot use user name and password in connection string. ASP.NET application should use Entity Framework 4.0 to work with data. Any ideas how to do it?    

Database server connection limit exceeded..

I have an SSIS package and have been adding additional DFTs to it.  Where there are dependencies between transformations I identify them.  However where things can procceed in parallel I do not constrain them form a control flow standpoint.  After adding another DFT I am now getting package failure due to "Database server connection limit exceeded" (my local source database is SQL Anywhere and it has a max connections of 10 in production it will be full blown Sybase and will probably not be so constrained).  I think I can solve the problem just my making control flow dependencies to reduce the amount of parallel activity but I am wondering if there are other things I should consider doing.  For instance are there other settings I can tweak that tell SSIS to run parallel up to X connections out of a connection pool? (or something like that). Some may comment that this relates to my post of yesterday on package strategy (master-child packages or one big package).  I still have one big package for now but may break it into master-child.  Still I think I can control the amount of parallel activities through control flow even if it remains one package. Any thoughts or comments on this would be appreciated. - Charles PS - just ran my package and this time it succeeded - sometimes I hit the limit of 10 connections sometimes not...

SQL Server Express 2005 connection timeout issue.

Client: Sql Sever Management Studio Express 2005 (SSMSE) on Vista Server: Sql Server 2005 Express on Windows Server 2008 Standard When I first try to log into SSMSE from the client machine, the login operation times out. When I retry, the login succeeds almost immediately. If I close the app and re-open it, the same thing happens. This appears to be infinitely repeatable. I am able to reproduce this behavior using SQLCMD.exe. Here's the error: "Timeout expired. The timeout elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server)" The technical details reference Error Number -2 What may be unique or tricky about this client's network is that it's a mixture of IPv4 and IPv6. I believe the server is configured for both, but honestly the networking side of things is outside of my expertise. Has anyone else experienced a problem like this? I'm looking for some troubleshooting tips and of course a flat-out answer :-). Thank you in advance for your time and expertise - I hope I've broken the problem down to its simplest form. Will.

SQL Database Connection Timeout

How do you modify the default 15 second timeout Connection Timeout on SQL databases in SQL 2005, for all users? I am able to modify the value on an individual basis through the options menu on the SQL Server 2005 login window however when signing on as a different user the changes do not carry to that users profile.

SQL 2005 open connection timeout error


We have Microsoft SQL Server 2005 - 9.00.4207.00 (X64)  Enterprise Edition (64-bit) on Windows server 2003 (Build 3790: Service Pack 2) .

Periodically (~ once per 15 min) some db-clients have error messages when open connection (over SQL Native Client ) like:

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

All timeouts more or equal 15 sec. Less then 15 sec is not acceptable by business rules. Performance counters (cpu,memory,disk etc.) on server does not show bottleneck. Only one sql counter - logins/sec show trouble. When problem exists then this counter = 0. Also dramatically decrease many other counters - sql batch requests/sec, transactions/sec, cpu load and some ones. SQL Server "sleep" few seconds (4 - 5) and then accessible again.




Max Idle Time for a Connection in SQL Server 2005


Can you please let me know where I can set the MAX IDLE TIME for the SQL SERVER CONNECTION.

IS this the value set for the KEEp Alive propoerty in the sql server configuration Manager.


Timeout when opening connection?


I get this error message in the EventViewer every now and then:

Exception information: 
    Exception type: SqlException 
    Exception message: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. 
Request information: 
    Request URL: http://x/x.aspx 
    Request path: /x.aspx 
    User host address: xx
    Is authenticated: False 
    Authentication Type:  
    Thread account name: NT AUTHORITY\NETWORK SERVICE 
Thread information: 
    Thread ID: 19 
    Thread account name: NT AUTHORITY\NETWORK SERVICE 
    Is impersonating: False 
    Stack trace:    at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior

Connection timeout and command timeout : they working?


Hello everyone
I'm checking these parameters to connect to a server from a wireless client in the presence of little or no coverage to alert the operator of the problem.
I tried to lower both the timeout to 5 seconds. But if there is no connection sometimes takes 90 sec. sometimes only 45sec. first to tell me that is not 'unable to contact the server.
The connection string I use is' this:
Provider = SQLOLEDB.1; Persist Security Info = False; User ID = sa; Initial Catalog = Ideabiella; Data Source = localhost; Connect Timeout = 5;
and when I open the command also sets the CommandTimeout to 5sec.
where am I wrong?

hello and thanks

dmv to show connection timeout value


Can't seem to find a DMV that shows if there is a connection timeout value (as might have been set in the connection string), is that known at the SQL Server end of things?




Timeout connection error during


I have this strange problem during executing my dynamic data page:

Timeout. The available time expired prior to the completion of the operation or the server is not responding.
Description: Exception has been handled during execution of the current Web request. For more information about the error and where it originated in the code, see the stack trace.

Exception details: System.data.SqlClient.SqlException: Timeout. The available time expired prior to the completion of the operation or the server is not responding.

In debugger mode, the error is in the method:

public DynamicDataEntities(global::System.Data.EntityClient.EntityConnection connection) :
                base(connection, "DynamicDataEntities")

of my DynamicDataModel.designer.cs
in my solution.

But I have not other problems.

How can I solve?

Thanks in advance.


C# SqlServer connection timeout problem

hello,i have a problem ,when i connect to a sqlserver database,if the machine has closed,or the machine have not a sqlserver service,my progrem will block about 30s,it's too long,so i change the connection string like that
SqlConnection con = new SqlConnection("server=;uid=sa;pwd=itneste;database=FileTransport;Connection Timeout=5;");

and i set the command timeout =5,but not effect......
what's the problem,and how do?

Connection pool does not match between master.dbo.sysprocesses and Performance counter - Numberofpoo

Recently i got the 'A transport-level error has occurred when sending the request to the server.' error,

I checked master.dbo.sysprocesses and found there were 4 connections, but when i checked Performance counter - .NET data provider for sqlserver NumberofpooledConnection

there were 7 connections, is it means the some of connection in connection pool is not avaiable any more?

How ADO.net manage connection pool to create a new connection


We are using SQL SERVER 2008 and windows 2008 R2


I don't have a idea that we have a connection pool with max pool size =200,  our maximum concurrent user is around 50, but i do see there are nearly 170+ connection in SQL Server (using Sp_who2)

As what i understand is ADO.net create a new connection only when there is not free(in-active) connection in the connection pool and connection will return back to pool after it has been closed, however in my case, our concurrent user is only around 50,  sql server connection should not be 170+ , should be around our maximum concurrent users is it? (notes, 170+ connections i only count with program_name : '.Net SqlClient Data Provider '

Anything i understand wrongly, Please point it out. Thanks in advance.


SSRS 2008: connection failure, timeout or low disk condition within the database. (rsReportServerDat



I have started getting this error since a week now when I try to schedule a report or change a schedule of a report. 

An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. (rsReportServerDatabaseError) Get Online Help For more information about this error navigate to the report server on the local server machine, or enable remote errors 


We have SQL Server 2008 installed along with SSRS running on the server. I have never seen this happening before for almost a year now but suddenly it appeared.  Along with this, report subscription is also messed up and some report are not been emailed as they have a error like:

Failure sending mail: An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database.Mail will not be resent. 


I am not sure what caused this but if anyone has any idea of what is going on it will be great. 


Thanks you for your help. 

Please reply soooon !!!

Connection timeout being ignored


Hi all,

Have a query that takes approx 30 seconds to execute when run from sql server management studio (sql2005), however when

I execute this query from a .net page using enterprise libray it times out after approx one minute.  The connection timeout on

the sql connection string is 600 seconds.

Does anyone know how I can set a timeout for this?

The code below shows the C# code




public IEnumerable<CustomerList> GetCustomerList(CustomerEntity ce)
            ParameterMapper pm = new ParameterMapper(new List<String>() 
                "@CustomerID", "@FirstName", "@LastName", "@Organisation", 
                "@Address", "@CountryCode", "@PostCode", "@InvoiceNumber", "@CompanyCode" 

            DataAccessor<CustomerList> customerAccessor = this.db.CreateSprocAccessor(
                    .Map(x => x.ReformattedRefNo).ToColumn("ReformattedRefNo")
                    .Map(x => x.ReformattedAddress).ToColumn("ReformattedAddress")
                    .Map(x => x.CountryCode).ToColumn("COUNTRY_CODE")
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend