Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Random General network error.

Author  Topic 

nlaforet
Starting Member

1 Post

Posted - 2008-08-04 : 05:27:57
Hi all,

We've 2 SQL servers, the source (SQL 2000 SP4) on witch i've a sp launched by an agent each 15 minutes, that insert/update some tables on a destination server (SQL 2003) on a DMZ. During the day i've maybe 1 or 2 errors but i've got 20-30 each night :

quote:
Message
Exécuté en tant qu'utilisateur*: blablabla. Erreur réseau générale. Consultez la documentation relative à votre réseau [SQLSTATE 42000] (erreur 11) [SQLSTATE 01000] (erreur 7312) [SQLSTATE 01000] (erreur 7312). L'étape a échoué.


Translation could be : General network error. Check your
network documentation

The agent execute some sp, not only one ... and the error appear randomly on some steps ...

The step of the work will be good during hours, and the job stop with this error, some minutes later the job could pass or made the same error ... but the job finish by being executed completely ...

Have you got an idea of solution ?

Thanks.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-08-04 : 14:34:17
It seems like its a network issue.
Go to Top of Page
   

- Advertisement -