Consistent error occuring in SQL Server 2005

Tags:
SQL error messages
SQL Server 2005
Windows Server 2003
I have five servers in my network. On one member server, I have SQL 2005 Standard ver.9.00.1399.00 running on MS Server 2003 R2 SP2. In my event log on this server, I am receiving an error every couple minutes. They show up in the SQL error log as well as the event viewer. The error is: Event Type: Error Event Source: SQLSERVERAGENT Event Category: Alert Engine Event ID: 319 Date: 6/18/2008 Time: 12:00:30 AM User: N/A Computer: AGEDATASERV03 Description: Cyclical forwarding detected for event 3197: Event source was 'AGEDATASERV03' which matches the current forwarding server. The event was not forwarded.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Is AGEDATASERV03 the name of the machine which has these errors? If it is this is because you have setup message forwarding from this server to it self, or you are forwarding the messages to another server, and that server is forwarding the messages back.

Disable the message forwarding on one or both of the machines and the error should go away.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following