May 16, 2012 at 10:56 am
At one of our 10 remote sites, we are getting allot of login failures with this message - 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.) The other 9 sites don't experience this problem.
I confirmed that MAX number of connections is set to 0. Not using a VPN and all clients are Win XP SP2.
I remoted into a machine at this site and installed SSMS on a machine to test this. Sure enough, using SQL authentication under sa and a few other user accounts, I and got login errors about every other try and the connection was also being abruptly closed as well after successfully connecting.
I logged in using Windows authentication and did not seem to have any issues.
Not running any windows firewalls or other firewalls between the desktop and DB server.
May 16, 2012 at 12:03 pm
Did you notice any network issue? Is it only for SQL Server connections or do you get hiccups while pinging or RDP.
May 16, 2012 at 12:26 pm
Check the Firewall (or router, etc.) filter settings (protocol, port, ...). This includes the software firewalls built into MS Windows OS.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
May 16, 2012 at 12:40 pm
We reset the riverbed Wan compresion hardware and it seems to have cleared this up for now. I will need to keep an eye on it but hopefully this is the problem. The Riverbed devices did not show any errors so this is still pretty mysterious.
May 16, 2012 at 2:24 pm
It's usually something blocking port 1433 (or whichever one you are using). It let's the authorization finish, but SQL Server cannot finish the TDS hand-shake (or something like that, it's not my area...)
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply