SQL Server 2005 and 'General network error'
- by Mariusz
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.
