Connection breaks in-between with exceptions.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » Data Corruption (SS2K8 / SS2K8 R2) » Connection breaks in-between with exceptions....

Connection breaks in-between with exceptions.

Rate Topic

Display Mode

Topic Options

Author

Message

Yogesh Khaire

Posted Thursday, August 02, 2012 6:18 AM

Grasshopper

Group: General Forum Members
Last Login: Saturday, April 20, 2013 10:54 PM
Points: 14, Visits: 45

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

Post #1339083

db_expert_pradeep

Posted Tuesday, August 07, 2012 2:36 AM

Grasshopper

Group: General Forum Members
Last Login: Yesterday @ 2:06 AM
Points: 18, Visits: 378

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

Post #1341066

« Prev Topic | Next Topic »

Permissions