Connection breaks in-between with exceptions.

• Yogesh Khaire

  SSC-Addicted

  Points: 402

  More actions

  August 2, 2012 at 6:18 am

  #264564

  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

• db_expert_pradeep

  SSC Veteran

  Points: 294

  More actions

  August 7, 2012 at 2:36 am

  #1522436

  Please check browser port is 1434 is open or not

  run below command

  telnet servername 1434

  if this is not open you have to add in coonection string

  instancename,tcpip port

  if this is running on default port thenlike below:

  instancename,1433

  Pradeep

  DBA Vertex Data Inc