Re: 10054:A transport-level error has occurred when sending the re

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi Rick,

Thank u for ur time.

i checked the URL
but my application is neither using native code nor the corrupted-hardware.
and the last workaround turning off syncattackprotect can not be applied on
production application as said in msdn.

if u have any other suggestions plz let me know

"Rick Byham, MSFT" wrote:

This info in SQL Server 2008 Books Online can also apply to SQL Server 2005.
http://msdn.microsoft.com/en-us/library/ms187005.aspx
--
Rick Byham, MSFT
(Implies no warranty or rights)


"Jamdelv" <Jamdelv@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FDD9A9B5-C70A-48B7-8742-E6799C1F5892@xxxxxxxxxxxxxxxx
HI
My application encountered an issue as mentioned below after migrating the
sql server to 2005.

10054: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.)

application was kept idle for 17 min and we got this issue.but the
patterns
in which the error is raised is quite interesting.The application also
kept
idle for more than half an hour ,to just to reproduce it but just to see a
failured attempt.
Guess,there are other factors causing the appliactions to break not just
the
application's idle time..
saw the same issue in some of the forums..but to my surprise there is no
robust solution thus far..
please provide any help in the right directions



.

Relevant Pages

  • Re: 10054:A transport-level error has occurred when sending the reques
    ... This info in SQL Server 2008 Books Online can also apply to SQL Server 2005. ... (Implies no warranty or rights) ... (provider: TCP Provider, error: 0 - An existing connection was ... application was kept idle for 17 min and we got this issue.but the ...
    (microsoft.public.sqlserver.connect)
  • Question about scheduled job
    ... You are the administrator of SQL Server 2000 computer. ... Modify SQL Server Agent properties and specify a smaller idle time. ... Write a stored procedure that executes the job whenever the @@ IDLE ...
    (microsoft.public.sqlserver.server)
  • Re: Arithmetic overflow occured when running sp_monitor.
    ... @idle as well as @@CPU_BUSY both return an integer of the ... number of milliseconds since SQL Server was last started so ... >Arithmetic overflow error converting expression to data type int. ...
    (microsoft.public.sqlserver.server)
  • shut down status on full text index incremental population
    ... I have a full text index scheduled at every night in SQL server 2000. ... Normally the status on the full-text catalog will either "Idle" or ... Free up resources and restart the service. ... We have almost 300G of free disk space. ...
    (microsoft.public.sqlserver.fulltext)