Errors for sql server connection in asp server

• IT researcher

  SSCertifiable

  Points: 7567

  More actions

  March 13, 2013 at 11:03 pm

  #394388

  In an asp server we are getting error for SQL server connection like below

  [highlight="#FAFAD2"]

  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.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)

  at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

  at System.Data.SqlClient.SqlConnection.Open()

  at AutoRenReg.ConnectToSQLDB()

  [/highlight]

  Also after the ExecuteScalar, ExecuteReader and ExecuteNonQuery i am getting error like

  [highlight="#FAFAD2 "]

  System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)

  at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

  at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

  at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

  at System.Data.SqlClient.TdsParserStateObject.WriteSni()

  at System.Data.SqlClient.TdsParserStateObject.WritePacket(Byte flushMode)

  at System.Data.SqlClient.TdsParserStateObject.ExecuteFlush()

  at System.Data.SqlClient.TdsParser.TdsExecuteSQLBatch(String text, Int32 timeout, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj)

  at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

  at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

  at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

  at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

  at System.Data.SqlClient.SqlCommand.ExecuteReader()

  at WinMsg.Page_Load(Object sender, EventArgs e)

  [/highlight]

  Both errors not seen always.But it happens sometime.So what may be reason for these error?How to solve it?