error connecting: timeout expired.In iis ?

Question

Hi All , I have issue in iis . after deployment . when too many users accessing at the same time, i am facing the follwing error. How to resolve this. I have searched through google. Everyone says connection not been closed properly.but i have closed the connection properly. so what would be cause this error. If someone pass through this error suggest me with suitable solution. error connecting: timeout expired. The timeout period elasped prior to obtaining a connection from the pool. Thanks Karthik.K

Piyush Pansuriya · Answer

Hi Karthik, Yes, it is because of your connetion not closed properly or This may have occurred because all pooled connections were in use and max pool size was reached. So, close your database connection in finally SqlConnection myConnection = new SqlConnection(ConnectionString); try { conn.Open(); someCall (myConnection); } finally { myConnection.Close(); } or using (SqlConnection myConnection = new SqlConnection(ConnectionString)) { myConnection.Open(); someCall(myConnection); } Or Increase the max pool size ncrease pool size like in your connection string string connectionString = "Data Source=localhost; Initial Catalog=Northwind;" + "Integrated Security=SSPI; Min Pool Size=10; Max Pool Size=100" ; or Don't use pooling at all string connectionString = "Data Source=localhost; Initial Catalog=Northwind;" + "Integrated Security=SSPI; Pooling=false;" ;

Mageshwaran R · Answer

Hey Karthik, Try this, public class Common { SqlConnection sqlCon= null ; String SqlconString=ConfigurationManager.ConnectionStrings[ "SqlConnectionString" ].ConnectionString; public void Test( string firstName) { using (sqlCon= new SqlConnection(SqlconString)) { sqlCon.Open(); SqlCommand sql_cmnd = new SqlCommand( "PROC_NAME" , sqlCon); sql_cmnd.CommandType = CommandType.StoredProcedure; sql_cmnd.Parameters.AddWithValue( "@FIRST_NAME" , SqlDbType.NVarChar).Value=firstName; sql_cmnd.ExecuteNonQuery(); sqlCon.Close(); } } } WebConfig: connectionStrings > add name = "SqlConnectionString" connectionString = "Data Source=Servername;Initial Catalog=Database_Name;Integrated Security=true" /> connectionStrings >

Sachin Singh · Answer

ofcourse you can increase the Max Pool size to 500 or more , but this is not a solution at all . you must have a connection leak that needs to be fixed find the leaked dataconnection , there is a readymade class in this article , you need to download and use to monitor https://www.codeproject.com/Articles/12296/Find-quot-Leaked-quot-Database-Connections-in-ASP