we face 3 exception when we connect through the client also slow down the performance.
exceptions are a follows:
1) System.Data.SqlClient.SqlException (0x80131904): A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.)
2) System.Data.SqlClient.SqlException (0x80131904): A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
3) System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Windows Server 2008 R2 with SP1 (64-bit)
RAM 16 GB
SQL Server 2008 R2
Client machine have Windows7
Please help somebody