海阔天高

暂无签名

  • 博客访问: 1036412
  • 博文数量: 280
  • 用 户 组: 普通用户
  • 注册时间: 2009-04-22 00:56
个人简介

暂无介绍

文章分类

全部博文(280)

文章存档

2016年(1)

2013年(11)

2012年(37)

2011年(25)

2010年(44)

2009年(31)

2008年(15)

2007年(17)

2006年(47)

2005年(49)

2004年(2)

2000年(1)

我的朋友

分类: SQL Server

2011-01-26 10:14:59

SQL Server连接错误解决方法列表[@more@]

1. Connection Forcibly Closed

This error may occur when connecting to SQL Server using TCP/IP.
Error message:A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)

Related cause and solution:

(1). SynAttackProtect
SQL Server Database Engine running on Windows Server 2003 Service Pack 1 and later, Windows may drop connections if the requests arrive faster than SQL Server can service them. This is a security feature of Windows Server 2003 Service Pack 1 and later, which implements a finite queue for incoming TCP connection requests.
http://technet.microsoft.com/en-us/library/ms187005.aspx

(2) windows SNP feature, include TCP Chimney Offload, RSS and TCPA
http://support.microsoft.com/kb/942861/en
http://kitesky.itpub.net/post/909/512660

How to fix

(1). Edit registry
(2). Command

netsh int tcp show globalshows the offload setting in the OS.

netsh int tcp set global chimney=enabledenables the offload.

2. Transport-level Error When Querying DatabaseErrorMessage:A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)

Related cause and solution:The error is being caused by a timeout exception for long running queries. In previous versions of Visual Studio .NET, the exception was properly represented as a exception with a timeout description.
Set the commandtimeout property of the command object to an appropriate value. Use a value of zero to wait without an exception being thrown.
http://support.microsoft.com/kb/555938

阅读(3458) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~
评论热议
请登录后评论。

登录 注册