An existing connection was forcibly closed

2 New Member

Hi

I've started receiving sporadic SqlExceptions throughout my .NET applications (crossing ASP.NET, Windows Services, Winforms - doesn't seem application code specific):
System.Data.Sql Client.SqlExcep tion: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.

The SQL Server (Dell PE1950, 8GB ram, Quad Xeon 2.5G+) is relatively busy, while far from stressed out. Here are some relevant counters:
Avg. Diske Queue length: 0.012
Full Scans/sec: 200
Page splits/sec: 1.5
Buffer cache hit ratio: 99.850
Page life expectancy: 50,000+
Transactions/sec: 700
User connections: 235
Batch request/sec: 320
SQL Compilations/sec: 175
6,5GB dedicated memory.

All these numbers seem perfectly fine by me. My theory is that I'm running into some kind of TCP limitation, possibly the backlog size limit or the SynAttackProtec t issue:
http://blogs.msdn.com/sql_protocols/...ckprotect.aspx

While the server is powerful, no specific registry modifications have been made. I have not been able to find any documents on how to diagnose if it's either the tcp backlog or the SynAttack issue. As it's an important production server, I'm not too fond of just restarting it now and then to play around with the settings.

Anyone got some ideas?

Feb 26 '08 #1

Subscribe Reply

3901

radcaesar

759

Recognized Expert Contributor

Quick questions,

What is the SQL Server version ? Is it Express ?

Are you using Norton or Mcafee AV ?

Seems to be some network related issue, not SQL Server's.

Try using NamedPipes for connection instead of TCP/IP.

Feb 28 '08 #2

OrcaDK

New Member

Quick questions,

What is the SQL Server version ? Is it Express ?

Are you using Norton or Mcafee AV ?

Seems to be some network related issue, not SQL Server's.

Try using NamedPipes for connection instead of TCP/IP.

It's SQL Server Standard x64. Using Microsoft Forefront Client security. I can't use named pipes as the SQL server is not running on a dedicated machine. I do believe as well that it might be a networking issue, that's why I'm suspecting the tcp backlog or the SynAttackProtec t settings. I cannot however reboot away and test changing these settings as it's an important production machine.

Feb 28 '08 #3

Similar topics

603

Underlying connection was closed

by: samy | last post by:

I have an application which invokes(calls) a webservice (on IIS 5.0 , windows 2K) every 10 seconds. After a long time(about 4 hours),the call to the webservice fails with the error System.Net.WebException: The underlying connection was closed: An unexpected error occurred on a send at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest request at...

.NET Framework

2397

"An existing connection was forcibly closed by the remote host"

by: Mike | last post by:

VB .NET 2003, Pocket PC 2003, CF 1.0 SP 2 Only when I use a proxy server, I'm getting this error when attempting to write data to a Stream object from an HTTPWebRequest object. (System.IO.Stream.Write() raises the exception):"An existing connection was forcibly closed by the remote host". The error only happens with fairly large amounts of data (around 24,500 bytes). Here is ToString() of the exception object raised:

Visual Basic .NET

1966

SSL: "An existing connection was forcibly closed by the remote host."

by: SisAndz | last post by:

Hello, I'm trying to do a secure connect to the site https://212.77.100.18/p/ with ..net 2.0 HttpWebRequest class, unfortunately for some reason I'm not able to do that - WebException is thrown with inner exception message of "An existing connection was forcibly closed by the remote host." I hoped I'll solve my problem with RemoteCertificateValidationCallback delegate which always returns "true", but it isn't called at all for this...

C# / C Sharp

1206

ASP State: An existing connection was forcibly closed by...

by: Sanjay T | last post by:

Hi, We are using ASP.Net 2005 and SQL Server 2005. We are storing sessions in the database. From time to time we get the following exception in the application while the ASP.Net session tries accessing the database. This also happens from time to time when our application is accessing the database. To make the posting brief, I am just putting part of the exception. Any ideas why this might be happening? Our web application is behind F5...

ASP.NET

12675

An existing connection was forcibly closed by the remote host

by: balaya | last post by:

was an error downloading 'https://pushmxtest.equitynational.com/EquityNational/PushMXService.svc/secure'. The underlying connection was closed: An unexpected error occurred on a receive. Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. An existing connection was forcibly closed by the remote host

.NET Framework

2228

Cassini fails with An existing connection was forcibly closed by the remote host

by: Anbu | last post by:

Hi All, I'm using the Cassini component in my desktop application to create a web site to host the web services. The application works fine in normal scenario. If the system is kept idle for some time, the application getting terminated with the following error: Unhandled Exception : An existing connection was forcibly closed by the remote host at System.Net.Sockets.Socket.Send(Byte buffer, Int32 offset, Int32

ASP.NET

4443

"an existing connection was forcibly closed by the remote host"

by: Jim Hubbard | last post by:

We are using a .Net 2.0 app that connects to a SQL 2005 Express DB and we keep getting this message on the clients. Has anyone seen this error or a solution to it?

.NET Framework

3053

"An existing connection was forcibly closed by the remote host "

by: rhepsi | last post by:

hii all, When im trying to upload all the resized photos from the local server onto the live ftp server, im getting an error stating tht: "An existing connection was forcibly closed by the remote host " For n= 0 To lstFileNames.Items.Count - 1 Step 1 Try xImg1 = lstFileNames.Items(n).ToString() ff.UploadFile(xImg1)

.NET Framework

8678

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8609

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

9166

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

9030

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8899

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

7737

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

4371

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

3052

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2333

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP