Solved

connection forcibly closed error

Posted on 2012-03-15
6
695 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
  • 4
  • 2
6 Comments
 
LVL 39

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 39

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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
LVL 39

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 39

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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

806 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