24412

SQL Server 2005 and 'General network error'

Question:

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:

<blockquote>

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

</blockquote>

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.

Answer1:

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

Check out this link for ideas <a href="http://blogs.msdn.com/sql_protocols/archive/2005/10/29/486861.aspx" rel="nofollow">http://blogs.msdn.com/sql_protocols/archive/2005/10/29/486861.aspx</a>

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.

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.

Recommend

  • How do I connect to my Amazon RedShift cluster using Python?
  • C# (async / await) loop in task block my main thread?
  • Configuring an Access report to use a SQL Server stored procedure as its record source
  • An unhandled exception of type 'System.InvalidOperationException' occurred in System.Data.
  • Setting Maven for scripting languages?
  • Fresh Rails 4 app is not recognizing `rails` commands, insists that I use `rails new`
  • Why do I have to use LD_PRELOAD for libcl.2 to use XML::LibXML::Common on HP/UX?
  • Maven - which projects or techologies you are using it for?
  • Open a file from the same package
  • Reading POM's with its children
  • How to preserve alias property while signing app?
  • Why won't my rails spec run?
  • Find the associated program to open a file using Java
  • Development workflow for server and client using Docker Compose?
  • Launching a new command window from Golang in Windows
  • JPA/Hibernate - Entity name seems to be important. If I rename to “Bob” works fine
  • Writing to Ontotext GraphDB using Jena
  • How to use : function in H2O ddply, R?
  • Ability to use Bootstrap 3 grid system to specify width of select element
  • Accessing local repository in offline mode
  • How to load Q library with Require.js?
  • Convert two columns Pandas data frame to dictionary of list with first column as keys
  • Portable JRE on Linux - possible?
  • C# List of Panels
  • How to retrieve information from antrun back to maven?
  • Servlet stops working on Tomcat server after some hits or time
  • Private IP address in reserved subnet range
  • Is it possible to open regedit and navigate to straight to a specific key using process.start?
  • How to Cache Real-time Data?
  • How to install a .deb file on a jailbroken iphone programmatically?
  • Asynchronous UI Testing in Xcode With Swift
  • Debugging ASP.NET on a built-in web server suddenly stops
  • script to move all files from one location to another location
  • How can I use Kendo UI with Razor?
  • ActionScript 2 vs ActionScript 3 performance
  • Hazelcast - OperationTimeoutException
  • Error creating VM instance in Google Compute Engine
  • What are the advantages and disadvantages of reading an entire file into a single String as opposed