Solved

connection forcibly closed error

Posted on 2012-03-15
6
700 Views
Last Modified: 2012-05-10
Can someone tell me what exactly this message means?

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
0
Comment
Question by:rochestermn
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 40

Expert Comment

by:lcohan
ID: 37726436
Most likely the (SQL) server dropped the connection - what is the service pack and what query was running on it? Sometimes MAXDOP = 1 query OPTION helps to alleviate these kind of errors in SQL along with query optimization and proper indexing.
0
 

Author Comment

by:rochestermn
ID: 37726639
This is the version.
Microsoft SQL Server 2008 (SP2) - 10.0.4064.0 (X64)   Feb 25 2011 13:56:11   Copyright (c) 1988-2008 Microsoft Corporation  Standard Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2)

Im pretty sure its a .net based web application that makes alot of connections to sql server but Im not sure where to find the exact error.  Windows event logs or sql logs.
0
 
LVL 40

Expert Comment

by:lcohan
ID: 37726660
You will find some details about the error in SQL but maybe not exactly what caused it and why SQL decided to term inate that process. I noticed these happening more often on SQL 2008 than previously however, SQL Server itself is no longer crashing or restarting (which is a way better thing) when a process like this may cause severe issue in SQL service otherwise.

You can use SQL SSMS to look at SQL logs under Management or on the server in the folder where SQL was installed in a path like:

Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log
0
Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

 
LVL 40

Expert Comment

by:lcohan
ID: 37726667
0
 

Author Comment

by:rochestermn
ID: 37726892
I think the answer lies in here somewhere.  Its like an invalid user account or something.

Process information:
    Process ID: 2808
    Process name: w3wp.exe
    Account name: NT AUTHORITY\NETWORK SERVICE
 
Exception information:
    Exception type: SqlException
    Exception message: 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.)
 
Request information:
    Request URL:    Request path: /Default.aspx
    User host address:     User:  
    Is authenticated: False
    Authentication Type:  
    Thread account name: NT AUTHORITY\NETWORK SERVICE
0
 
LVL 40

Accepted Solution

by:
lcohan earned 500 total points
ID: 37727358
If you look under service most likely you will see your SQL Server service running under NT AUTHORITY\NETWORK SERVICE but details above won't give you the reason why SQL dropped that connection. Is this hapening often? If yes, you could use SQL Profiler to trace all sql acctivity but caution that you could bring the sql server down if you just run the defualt trace against it.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question