Solved

connection forcibly closed error

Posted on 2012-03-15
6
692 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
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 
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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

744 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now