Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

connection forcibly closed error

Posted on 2012-03-15
6
Medium Priority
?
704 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 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
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
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 1000 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
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, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

926 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