A special GNE (General Network Error) messages when running SQL Server after installing service pack 1 for Windows Server 2003 and TCP registry key SynAttackProtect

re: More GNE (General Network Error) messages when running SQL Server after installing service pack 1 for Windows Server 2003 and TCP registry key SynAttackProtect

Steve Dawes — Fri, 02 Jun 2006 19:04:33 GMT

One way to help users to diagnose this kind of problem is to be able to demonstrate it and exacerbate it under test conditions.

Can you cobble together a simple script that will stress the SynAttack logic to be able to demonstrate the problem with a live application. This test can then be included with some UAT acceptance testing of applications.

Thanks

re: More GNE (General Network Error) messages when running SQL Server after installing service pack 1 for Windows Server 2003 and TCP registry key SynAttackProtect

daern — Mon, 04 Dec 2006 20:06:22 GMT

This is an awesome blog posting. Unfortunately, I think you got the registry key wrong...

It should be SynAttackProtect not SycAttackProtect

http://technet2.microsoft.com/WindowsServer/en/Library/8d3a9f4d-13d1-4280-ac57-30242504d8ba1033.mspx

Daern

Problema com SQL Server e W2003 Server - eventual, mas sério

Dennes — Tue, 05 Dec 2006 05:07:59 GMT

O problema afeta as versões 2000 e 2005 do SQL Server, quando este roda em um servidor Windows...

General advice on SQL Server General Network Errors

Peterson's Ponderings — Sat, 24 Mar 2007 19:52:01 GMT

Arghh, what are these "General Network Error" messages? You know the ones, that randomly with...

re: A special GNE (General Network Error) messages when running SQL Server after installing service pack 1 for Windows Server 2003 and TCP registry key SynAttackProtect

SQL Protocols — Mon, 26 Mar 2007 21:22:39 GMT

Thanks Daern for the correction on a typo.

re: A special GNE (General Network Error) messages when running SQL Server after installing service pack 1 for Windows Server 2003 and TCP registry key SynAttackProtect

SQL Protocols — Mon, 26 Mar 2007 21:26:42 GMT

Peterson,

The GNE is the type of error message with MDAC. With SNAC and ADO.net2.0, the error messages are improved and lots of issues can be identified much faster and easier. If you see GNE issues, please post your finding here or on the forum,

at http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=87&SiteID=1

Thanks,

re: A special GNE (General Network Error) messages when running SQL Server after installing service pack 1 for Windows Server 2003 and TCP registry key SynAttackProtect

kwthong — Tue, 17 Apr 2007 09:48:49 GMT

Hi there,

I'm facing the same problem. When i make changes to the registry, it resolved the problem at internal environment. However changes on live environment had not effect. The error still occur. Any ideas what else is missed?

re: A special GNE (General Network Error) messages when running SQL Server after installing service pack 1 for Windows Server 2003 and TCP registry key SynAttackProtect

Vineet — Tue, 22 May 2007 18:10:37 GMT

Hi All,

I am getting the same error message([DBNETLIB]General network error. Check your network documentation).

We are using MS SQL 2000 but the operating system is Windows Server 2000 SP2. Can anybody tell me if the reason of this problem on Windows 2000 server is also same or can it be due to some other reason?

Thanks in advance

Vineet

re: A special GNE (General Network Error) messages when running SQL Server after installing service pack 1 for Windows Server 2003 and TCP registry key SynAttackProtect

Barretto VN — Sun, 15 Jul 2007 16:52:14 GMT

"General Network error .........."

This error message really got me worked, but fortunately i was able to find the reason.

To replicate the error you need to have SQL Server Management Studio (2005) may be with SQL Server 2000 it is Enterprise Manager, but not MSDE.

You may create a small VB.NET app using the following code

Dim conn as SqlConnection

Dim cmd as SqlCommand

' Remember to change values between []

Try

conn = New SqlConnection("Data Source=" + [Your Server Name] + ";Integrated Security=false; User ID=" + [Your User Name] + ";Password=" + "Your Password" + ";")

conn.Open()

cmd = New SqlCommand

cmd.Connection = conn

cmd.CommandText = "CREATE DATABASE [aftermarket]"

cmd.ExecuteNonQuery()

Catch ex As SqlException

Console.WriteLine(ex.Message)

' OR following if under Winforms

MessageBox.Show(ex.Message)

Finally

conn.Close()

End Try

You may create a small C# app using the following code

SqlConnection conn;

SqlCommand cmd ;

try

{

// Remember to change values between []

conn = new SqlConnection("Data Source=" + [Your Server Name] + ";Integrated Security=false; User ID=" + [Your User Name] + ";Password=" + "Your Password" + ";");

conn.Open();

cmd = new SqlCommand();

cmd.Connection = conn;

cmd.CommandText = "CREATE DATABASE [MyDatabase]";

cmd.ExecuteNonQuery();

}

catch (SqlException ex)

{

Console.WriteLine(ex.Message);

// OR following if under Winforms

MessageBox.Show(ex.Message);

}

finally

{

conn.Close();

}

Compile and run the app, hopefully a Database named "MyDatabase" will be created

Now start SQL Server Management Studio (for 2005) or Enterprise Manager (for 2000) and delete the Database just created, now run the app created earlier, you might get the dreaded error message, try to run the app atleast 3 times you will get the same error message.

Now question is , how do i correct the problem, simple - Reboot the system and try running the app again.

Indeed a painful way of overcomming an error message.

This error message ONLY show up when you have, and has no connection with the Timeout property.

Integrated Security=false

User ID=[Your User Name]

Password=[Your Password]

Note: This is Microsofts general-purpose error message and this solution may not work in all cases.

Barretto

EOleException error raised, with message: [DBNETLIB][ConnectionRead(recv()).] General network error. Check your network documentation

Nirmal — Wed, 14 Nov 2007 12:10:21 GMT

I get the following error msg while uploading a database to our corporate office's offline database server running MS SQL server 2000. The corporate office has to manually upload the data from their server itself. This error has been raised since our VSAT provider updated their VSAT configuration (NET modem).

re: A special GNE (General Network Error) messages when running SQL Server after installing service pack 1 for Windows Server 2003 and TCP registry key SynAttackProtect

sachin lad — Thu, 22 Nov 2007 13:35:09 GMT

hello respected sir,

I am sachin lad from mumbai.

I am currently working in one of the software company.

I have getting one error while running the application on emulator.my operating system is win xp and sql server is threre.

please reply me as early as possible.

re: A special GNE (General Network Error) messages when running SQL Server after installing service pack 1 for Windows Server 2003 and TCP registry key SynAttackProtect

Michael Thomas — Mon, 23 Jun 2008 20:58:59 GMT

I saw this same error with SQL Server 2005. After much thrashing, I found that the problem was being caused by changes to the TCP/IP registry parameters, specifically

TcpMaxConnectRetransmissions and TcpMaxDataRetransmissions, both of which set to 0. Changing these values both to 2 solved the database problem.

Note: These parameters were originally set to 0 for good reason: to prevent unreasonably long timeouts when trying to access disconnected network devices. And it makes no sense that SQL Server would need to retry in this case, since the client application is on the same machine as the server. But it is what it is, so I have to sacrifice performance of my network data collection application to get SQL Server to work at all.

[DBNETLIB][ConnectionRead(recv()).]General Network error.Check your network documantation.

Buddah — Mon, 28 Jul 2008 16:29:34 GMT

I'm using DTS to upload data from text file to sql 2000 database,When i'm loading 70000 records its work fine,but when i'm trying to load more than 70000(3 Million Records) I'm getting this error message, please help."[DBNETLIB][ConnectionRead(recv()).]General Network error.Check your network documantation."

re: A special GNE (General Network Error) messages when running SQL Server after installing service pack 1 for Windows Server 2003 and TCP registry key SynAttackProtect

RobinHood — Wed, 12 Nov 2008 23:06:28 GMT

I got the error message, and we resolved it by changing the "Enable NetBIOS over TCP/IP" setting radio button under the "WINS" tab in the Advanced TCP/IP settings. Also, be sure and check your binding order and NIC cards under Device Manager: we had one disabled.

re: A special GNE (General Network Error) messages when running SQL Server after installing service pack 1 for Windows Server 2003 and TCP registry key SynAttackProtect

jerryonnet — Fri, 20 Mar 2009 05:03:08 GMT

in my production server. I got the error message. But when I upgrade NTWDBLIB.DLL from 7.0 to 8.0. No more the error message appeared.

re: A special GNE (General Network Error) messages when running SQL Server after installing service pack 1 for Windows Server 2003 and TCP registry key SynAttackProtect

djoko — Thu, 28 May 2009 21:49:24 GMT

Hello,

I tried all your solutions.. still this error, after few minutes connected on few PCs (2 pcs work fine):(

I change:

- New server (+ domain, bulit new Clients in AD),

- Other Switch,

- Other router,

my platform: SBS 2008 (domain controller), SQL 2008 (in mixed mode, Firewall added exceptions sqlsrv.exe & sqlagent.exe and port 1434). DNS running on server. DNS 1 on server = SERVER IP, DNS = blank

Router (buffalo): lan settings, dns1 = server ip; dns 2&3 = provider dns ip, WINS = server ip

This SQL base was created in SQL 2000 MSDE (2x per day ERORR), than restored in SQL 2005 Express (ERROR after few mins) and now restored in SQL 2008 Std. (Error also in few minutes). Can be database, UTP cables?

Local area and internet work fine all the time.

sry for my eng.

Thanks,

re: A special GNE (General Network Error) messages when running SQL Server after installing service pack 1 for Windows Server 2003 and TCP registry key SynAttackProtect

djoko — Thu, 28 May 2009 22:20:45 GMT

one more:

on clients are Bussines security (nod32 with FW), i dont know how to disable this fw or add some exception?

re: A special GNE (General Network Error) messages when running SQL Server after installing service pack 1 for Windows Server 2003 and TCP registry key SynAttackProtect

FRVSoft — Fri, 23 Oct 2009 12:47:31 GMT

Check your NIC and upgrade it, and take a look at http://support.microsoft.com/kb/942861