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?