none
A connection was successfully established with the server, but then an error occurred during the login process.

    General discussion

  • Having encountered this error and not seeing a good answer on this (very old) question, I wrote a blog entry that describes an easy fix. It does involve candy and/or roses though.

     

    "A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)"

     

    http://betav.com/blog/billva/2008/11/solution-forcibly-closed-sql-s.html#more

    • Moved by Bob BeaucheminMVP Saturday, July 02, 2011 2:15 AM Moved to a more appropriate forum (From:.NET Framework inside SQL Server)
    Monday, December 01, 2008 1:30 AM

All replies

  • Thanks William. But the link seems to be broken. Can you please provide the solution here? I am facing this issue and need to fix it soon. Thanks, Manoj Deshpande.
    Thanks very much, Manoj Deshpande.
    Monday, May 16, 2011 6:53 AM
  • First I have to thank you for your link. It took me over 40 minutes of searching to find your REAL FIX to the problem. You state, "No, it has nothing to do with named pipes or TCP/IP protocols or using wireless connections or VPNs" Which were all the fixes I found before coming across this page and your link that explains the fix.

    (No, it has nothing to do with named pipes or TCP/IP protocols or using wireless connections or VPNs)

    I cannot tell you how frustrating it is to hunt or figure out fixes based on poor information.


    In the last 10+ years I have not seen any improvement on "expert" tips on how to fix problems. I have almost always had to modify the claimed fix if not rework it completely. The fixes more often then not gave me ideas to try.

    My question for you, is how did you find this. This one I would not have figured out had I not been told. I never would have thought it was the number of connections. My number of connections was set to 5 and I was the only one trying to make a connection, so I would never have thought it was that. (I would have set the number higher before putting it to production and why it was set to 5, I have no idea)

    I hope you answer, At the very least I hope you see this Thank You.

     

     

    I tried to register on that blog site, but I am getting an error. Is the site still open for new registrations?

    I dont expect you to fix this, it is just an FYI

    Error sending mail (Error sending mail: smtp.betav.com not found connect to localhost failed (Unknown error) connect to localhost failed connect to localhost failed (Unknown error) no (more) retries! )

     

    Friday, July 01, 2011 3:29 AM
  •  It worked :)Thanks a lot William!!!
    Friday, February 10, 2012 5:51 PM
  • Just increment the number of concurrent connections (Right Click on the Server in Management Studio and under Connections you find this) to your fav. number :-) It works...
    Tuesday, June 19, 2012 4:28 PM
  • What is the fix if SQL is already set to "unlimited" connections - and this still occurs?
    Thursday, September 27, 2012 1:12 PM
  • For my case, resolved using:

    [Surface Area Configuration] set the [Local and remote connections] to [Using TCP/IP only].

    Before this the configuration is [Using both TCP/IP and named pipes].

    Thursday, July 25, 2013 6:37 PM
  • For my case, I resolved it by this way:

    Change server autentification method to Authentification SQL Server and Windows mode.

    And enable the login in the Status of the login properties.

    Wednesday, January 29, 2014 2:23 PM