general network error sql server 2008 West Peterborough New Hampshire

Address 33 Alpine St, Milford, NH 03055
Phone (603) 672-9090
Website Link

general network error sql server 2008 West Peterborough, New Hampshire

Check your network documentation. Opening a database connection (in your client application) 2. General Network Error when CommandTimeout insufficient for Sq General network error when making asynchronous calls to long sql General Network Error - MS Stumped Exception: General Network Error (!) General network You cannot rate topics.

If you are getting the same error it is firewall related, please check your firewall configuration. A MS Access front end that interrogates some of the tables (linked) once every 5 seconds using an On Timer Event3 There are 8 other threads running that are linked to Having a support professional to look at it, could be more cost- effective. -- Erland Sommarskog, SQL Server MVP, es**** Books Online for SQL Server SP3 at Jul 29 '05 Edited by - 1dmf on 05/04/2010 05:31:57 1dmf Starting Member 5 Posts Posted-05/11/2010: 05:02:34 Back to the drawing board, setting connectiontimeout and commandtimeout to 99999 has not fixed the

Reoccuring issue. - [DBNETLIB][ConnectionRead (recv()).]General ne... The results of Google on the error message cover a very wide spectrum of different causes (since this is a very generic error) and none of the scenarios found there are I posted this question on several discussion groups via Google and all. But what seems to matter is the OS on which we run the app.

at System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() After getting a fair number of these errors I get this one also: System.Data.SqlClient.SqlException: General network error. Please review the stack trace for more information about the error and where it originated in the code. The connection may have been broken and restored between the pings. –Chris Bednarski Jul 9 '10 at 11:40 That's just the thing - it isn't intermittent. Yes the servers do have dual network cards, but only 1 is enabled on either server.

Morons!!- LumbagoMy blog (yes, I have a blog now! You cannot vote within polls. These comments are posted in case someone else has a similar problem. Reoccuring issue. - [DBNETLIB][ConnectionRead (recv()).]General ne...

Check your network documentation.SQL State: 08S01    Native Error: 11State: 1    Severity: 16SQL Server Message: [DBNETLIB][ConnectionRead (recv()).]General network error. It also improves performance. I have to get this problem resolved PLEASE HELP!!!!!!!!! Sep 09, 2005 02:09 AM|sometech|LINK they are both already enabled, any other ideas?

Now to resolve it in Enterprise Manager right click and go to server properties and click on Network protocols and just enable Named Pipes and TCP/IP. You cannot send emails. To tell you the truth, I never got to the bottom cause of this problem either. An error message is only as good as what the supporting troubleshooting steps you have applied...You need to check the event logs on both servers- and see if there is additional

You may hit the maximum number of sockets open on the server side. We are not responsible for the information on third-party websites, and we cannot assist in implementing the solutions on these websites. As for the statement - I know exactly what stored procedure it is timing out on and it is the same procedure that's working just fine the rest of the time. In my case I don't think that was the problem as I had enabled those comms.

I thought that the SQL Server protocol even included an automatic ping functionality so that this doesn't happen. How should I calculate the determinant? Reoccuring issue. - [DBNETLIB][ConnectionRead (recv()).]General ne... You cannot edit your own events.

Privacy Policy Safe Harbor Terms of Use Acceptable Use Policy All rights reserved. Blocking is the only thing I can think of, but you seem to have ruled that out. Plain SELECT?

SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! The code would not tell you anything it is just an update statement but here it is: Thanks for the code. The timeout period elapsed prior to completion of the operation or the server is not responding. Check your network documentation. [DataDirect][ODBC SQL Server Driver][libssclient23]ConnectionOpen (()). [DataDirect][ODBC SQL Server Driver][libssclient23]Communication link failureDefect/Enhancement NumberCauseThe ODBC data source is incorrectly configuredThe specified hostname or IP-address is incorrectThe Microsoft SQL Server

You cannot post HTML code. Reply Caddre Contributor 4150 Points 5259 Posts Re: SOMEONE PLEASE HELP!!!!!!! Additionally you may want to make sure that modify SQL so that you pre-allocate 'growth' space. Are you using a hostname in your connection string?

I looked at errors log too - there are no errors. Browse other questions tagged sql-server general-network-error or ask your own question. This morning I found that after running for about 4 and a half hours it crashed with the following message:Number = 0x80004004Source = Microsoft OLE DB Provider for SQL Server Description It appears if and only if there has been a prolonged (several hours at least) idle time. –Vilx- Jul 9 '10 at 10:54 add a comment| Your Answer draft saved

Post #713671 « Prev Topic | Next Topic » Permissions You cannot post new topics. You cannot post new polls. Check your network documentation. Sep 16, 2005 05:05 PM|Caddre|LINK I have read on another forum this error is caused by firewall, do you have firewall on the Network?

Note that just the first person to use the app gets the error. Sep 10, 2005 06:21 PM|sometech|LINK Ok, I have tried it 3 ways now. Privacy Policy.