By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,543 Members | 2,085 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,543 IT Pros & Developers. It's quick & easy.

System.Data.SqlClient.SqlException: General network error ????

P: n/a
HK
I just moved an ASP.NET application to a new web server at a different
location of ours. The SQL Server machine was moved to that new location at
the same time as the web site DNS was pointed to the new server. Suddenly
I'm getting lots of intermittent errors of this type.

The switch/hub/repeater that routes the traffic at the new location is an
older one, if that makes any difference.

One thing that bothers me is that the SQL Server has since (the move) been
reporting NetBT errors in the event log (event ID 4319 "A duplicate name has
been detected on the TCP Network"). But there are no duplicate names on my
private tcp/ip network. I can only think that maybe that comes from the
fact that I am using an external public DNS server on the sql server now;
before I think I had it pointed at its own internal DNS service on the same
box. I don't know if this error is related.

The ASP.NET error is:

System.Data.SqlClient.SqlException: General network error. Check your
network documentation.
at System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior behavior)
at Microsoft.ApplicationBlocks.Data.SqlHelper.Execute Reader(SqlConnection
connection, SqlTransaction transaction, CommandType commandType, String
commandText, SqlParameter[] commandParameters, SqlConnectionOwnership
connectionOwnership)
at Microsoft.ApplicationBlocks.Data.SqlHelper.Execute Reader(String
connectionString, CommandType commandType, String commandText,
SqlParameter[] commandParameters)
at Microsoft.ApplicationBlocks.Data.SqlHelper.Execute Reader(String
connectionString, CommandType commandType, String commandText)
at myprogram.myclass.mymethod()
the method names vary and work intermittently; they are also methods calling
stored procs that are optimized and execute quickly from Query Analyzer.
Any thoughts/fixes?
Nov 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"HK" <re**************@notreal.com> wrote in
news:ZX******************@tornado.socal.rr.com:
I just moved an ASP.NET application to a new web server at a different
location of ours. The SQL Server machine was moved to that new
location at the same time as the web site DNS was pointed to the new
server. Suddenly I'm getting lots of intermittent errors of this
type.

The switch/hub/repeater that routes the traffic at the new location is
an older one, if that makes any difference. Any thoughts/fixes?

You're having network issues - time to get your network guru to debug your
network.

Nothing you can do about it in ASP.NET... basically .NET is having trouble
connecting (or maintaining a connection) to your SQL Server due to network
issues.

--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/
Nov 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Browse more ASP.NET Questions on Bytes