Error 10054 & Index was outside the bounds of the array .(system.Data)

Question

0.00/5 (No votes)

See more:

Win2008

SQL-Server-2008R2

Experts
I have two servers installed sqlserver management studio 2008r2 ,before update the windows (windows server 2008 standard ) can easily connect to remote server and vice versa.But after update iam unable to connect both servers to each other i face problem while connecting to server 1 the error

A connection was successfully established with the server, but then an error occurred during the log in process(provider :TCP provider ,error : 0- An existing connection was forcibly closed by the remote host.) ( Microsoft sqlserver ,error :10054 )

From the second server if i try to connect server 1 sql management studio i go error

Index was outside the bounds of the array .(system.Data)

SERVER 1

Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) Jun 28 2012 08:36:30 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

SERVER 2
Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64) Jun 28 2012 08:36:30 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

Both machine having same version

Posted 12-Dec-14 6:44am

sameer112

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Accepted Answer · 2014-12-12T10:19:00

Solution 1

Please, follow these instructions: Troubleshooting: Connection Forcibly Closed[^]

If it won't help, i would check additionally:
1) tcp/ip[^] or named pipes[^] connections are enabled
2) windows firewall enables remote connections[^] to sql server

Posted 12-Dec-14 10:19am

Maciej Los

Comments

sameer112 13-Dec-14 0:11am

Maciej Los,
I added the key SynAttackProtect in the registry and also restarted the server but no effect still having the same error. I checked the TCP/IP and named pipes are also enabled . The firewall is disabled in both servers.

Maciej Los 13-Dec-14 4:01am

I'd suggest to install the newest service pack for ms sql server: link [^].

sameer112 13-Dec-14 11:10am

I have installed the latest version of sqlserver but still having same error?

Microsoft SQL Server 2008 R2 (SP3) - 10.50.6000.34 (X64) Aug 19 2014 12:21:34 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <x64> (Build 7601: Service Pack 1)

sameer112 24-Dec-14 14:20pm

Thank you Maciej los
After restarting both server solution worked.

Maciej Los 25-Dec-14 4:20am

You're very welcome ;)