July 12, 2009

Resolving the error ‘An existing connection was forcibly closed by the remote host’




Have you been getting this error while connecting to SQL Server?

‘An existing connection was forcibly closed by the remote host’

Here are some possible reasons and solutions for this error :

- The version of SQL Native Client used on the client computer is not up to date. Try updating the SQL Native Client.

- Use the SQL Server Surface Area Configuration tool to make sure SQL Server is configured to accept remote connections.

- Connection pooling can be enabled and the server closes the connection due to the result of a restart or network failure. Sometimes connecting again solves the issue. Also ask the administrator if number of connections are being limited. Check this link if you facing issues from a web application

- At times there could be a problem with the Network Infrastructure. Contact your network administrator to investigate if packets are being sent across.

- If you receive this error on a Windows Server 2003 Service Pack 2 (SP2) or Windows Server 2003 Scalable Networking Pack (SNP) that has a TCP/IP Offload-enabled network adapter, check this KB article

These KB articles may prove helpful too -

http://support.microsoft.com/kb/919710

http://support.microsoft.com/kb/948496

http://support.microsoft.com/kb/914277


Did you like this post?
kick it on DotNetKicks.com
subscribe via rss subscribe via e-mail
print this post follow me on twitter


About The Author

Suprotim Agarwal, ASP.NET Architecture MVP works as an Architect Consultant and provides consultancy on how to design and develop Web applications.

Suprotim is also the founder and primary contributor to DevCurry, DotNetCurry and SQLServerCurry. He has also written an EBook 51 Recipes using jQuery with ASP.NET Controls.

Follow him on twitter @suprotimagarwal

 
  Feedback:

comments

2 Responses to "Resolving the error ‘An existing connection was forcibly closed by the remote host’"
  1. Anonymous said...
    November 28, 2010 at 8:26 AM

    "Resolving the error ‘An existing connection was forcibly closed by the remote host’"

  2. Anonymous said...
    September 6, 2012 at 12:50 AM

    I have the same error. Our IT department has made a proxy server and chanced the config of comp... Thats why this error in my program

 

Copyright © 2009-2014 All Rights Reserved for SQLServerCurry.com by Suprotim Agarwal | Terms and Conditions