Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Connection breaks in-between with exceptions. Expand / Collapse
Author
Message
Posted Thursday, August 2, 2012 6:18 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Tuesday, August 7, 2012 2:36 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, November 24, 2014 11:01 PM
Points: 18, Visits: 446
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 »

Add to briefcase

Permissions Expand / Collapse