错误10054&索引超出了数组的范围。（system.Data） [英] Error 10054 & Index was outside the bounds of the array .(system.Data)

问题描述

专家

我有两个服务器安装了sqlserver管理工作室2008r2，在更新windows之前（windows server 2008标准）可以轻松连接到远程服务器，反之亦然。但是更新后iam无法连接两者连接到服务器1时我遇到问题的服务器错误



与服务器成功建立连接，但在登录过程中发生错误（ provider：TCP提供程序，错误：0-远程主机强行关闭现有连接。）（Microsoft sqlserver，错误：10054）



来自第二台服务器我尝试连接服务器1 sql管理工作室我去错误



索引超出了数组的范围。（system.Data）



服务器1



Microsoft SQL Server 2008 R2（SP2） - 10.50.4000.0（X64）2012年6月28日08:36:30版权所有（c）Windows NT 6.1上的Microsoft Corporation Enterprise Edition（64位）< X64&g吨; （Build 7601：Service Pack 1）



服务器2

Microsoft SQL Server 2008 R2（SP2） - 10.50.4000.0（X64）Jun 28 2012 08:36:30版权所有（c）Windows NT 6.1上的Microsoft Corporation Enterprise Edition（64位）< X64> （Build 7601：Service Pack 1）



两台机器具有相同版本

解决方案

请按照这些说明：故障排除：强行关闭连接 [ ^ ]



如果不起作用，我会额外检查：

1） tcp / ip [ ^ ]或命名管道 [ ^ ]连接已启用

2） Windows防火墙启用远程连接 [ ^ ]到sql server

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

解决方案

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

这篇关于错误10054&amp;索引超出了数组的范围。（system.Data）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！