SQL Server 2005和“常规网络错误” [英] SQL Server 2005 and 'General network error'

问题描述

我知道互联网上有很多有关解决此问题的信息，但这并没有帮助我。

I know there is a lot of information in the Internet about solving this problem, but it didn't help me.

我的Delphi应用程序使用dbExpress控件访问数据库并执行SQL查询。但是，由于数据库连接失败，因此每两天一次就会停止工作。这会在具有不同Windows版本的多台不同计算机上发生。每个数据库上都安装了MSSQL Server 2005（版本9.0.4035）。

My Delphi application uses dbExpress controls to access the database and execute SQL queries. Once every couple of days, however, it stops working because the database connection fails. This happens on several different computers with different versions of Windows. MSSQL Server 2005 (version 9.0.4035) is installed on each of them.

上述应用程序每隔几秒钟执行一次查询，它们主要是插入命令。每隔几天，我都会收到一系列类似以下的异常：

The above mentioned application executes queries every couple of seconds, and they are mainly insert commands. Every couple of days I get a series of exceptions like the following one:

[DBNETLIB] [ConnectionOpen
（PreLoginHandshake（） ）。]常规网络
错误。检查您的网络
文档。

[DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General network error. Check your network documentation.

然后，在我手动重新启动SQL Server之前，它无法访问。

And then the SQL server becomes inaccessible until I restart it manually.

我在Internet上找到的信息说我应该安装一些Service Pack，更改一些注册表项等，但是相信我，这些都不起作用，我不知道还有什么

The information I found in the Internet say that I should install some service packs, change some registry entries etc., but believe me, none of these helps and I don't know what else to do now.

您能帮我解决这个问题吗？有任何线索或想法吗？如有必要，我可以为您提供有关服务器或应用程序的更多信息。

Could you please help me solve this problem? Any clues or ideas? I can give you some more information about the server or the application if necessary.

非常感谢。

推荐答案

您的连接字符串是什么样的？
网络连接之间是否存在防火墙（硬件或软件）？

What's your connection string look like? Are there firewalls (hardware or software) between the network connections?

查看此链接以获取想法 http://blogs.msdn.com/sql_protocols/archive/2005/10/29/486861.aspx

Check out this link for ideas http://blogs.msdn.com/sql_protocols/archive/2005/10/29/486861.aspx

重新阅读您的帖子，您需要重新启动SQL Server很有意思。通常，由于与SQL不相关的项目，这些网络错误会暂时转瞬即逝。也许您没有正确关闭所有连接。在SQL Server上执行 netstat -an，查看有多少tcpip连接徘徊。以及企业经理。由于必须重新启动SQL Server，因此我首先要看的是SQL Server本身的错误日志，然后是Windows事件日志。

Re-reading your post, it's quite interesting that you need to restart SQL Server..that's a pretty serious deal. Normally these network errors are fleeting due to non-sql related items. Perhaps you are not closing all your connections properly. Do a "netstat -an" on the SQL server and see how many tcpip connections are lingering around. Look in enterprise manager as well. Since you had to restart SQL Server, the first thing I'd look at is the Error logs of SQL Server itself and then the windows event logs.

看完之后的下一步在所有这些方面，如果您仍然遇到问题，那么我强烈建议您与Microsoft一起打开故障单。它通常并不昂贵，而且他们在这种事情上非常擅长。

Next step after looking at all this and if you are still experiencing problems then I would highly recommend to open up a trouble ticket with Microsoft. It's typically not expensive and they are quite good at this sort of thing.

这篇关于SQL Server 2005和“常规网络错误”的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！