SQL Server 2005 and 'General network error'
Posted
by Mariusz
on Stack Overflow
See other posts from Stack Overflow
or by Mariusz
Published on 2010-05-06T20:49:24Z
Indexed on
2010/05/06
20:58 UTC
Read the original article
Hit count: 557
I know there is a lot of information in the Internet about solving this problem, but it didn't help me.
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()).]General network error. Check your network documentation.
And then the SQL server becomes inaccessible until I restart it manually.
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.
Thank you very much in advance.
© Stack Overflow or respective owner