September 22, 2009 at 7:50 am
What does it mean when you find that your SQLAgent service terminated with error 3417?
It's the only "odd" event surrounding a period of time when my SQL Server stopped accepting connections.
A simple reboot fixed the issue, but I need to explain to my boss what happened.
Does anyone know what would cause the agent to terminate with error 3417?
September 22, 2009 at 7:55 am
Timothy.Cloud (9/22/2009)
What does it mean when you find that your SQLAgent service terminated with error 3417?It's the only "odd" event surrounding a period of time when my SQL Server stopped accepting connections.
A simple reboot fixed the issue, but I need to explain to my boss what happened.
Does anyone know what would cause the agent to terminate with error 3417?
it is a service related error, it can occur for various reasons. normally you see more information in the logs or event logs detailing why it failed. a restart of the sql agent should have worked in theory, rather than a reboot.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 22, 2009 at 8:02 am
Let the boss know someone submitted a Connect item on this error.
It looks from some searches that this is a master db error. Is that what you got? Anything in the error logs?
Does this help? http://blogs.msdn.com/psssql/archive/2008/09/10/upgrade-for-sql-server-2008-can-fail-if-you-have-renamed-the-sa-account.aspx
September 22, 2009 at 8:03 am
It is a very generic message, try to bring more details looking into Event Log also.
Is your server on SQL Cluster? I am asking because your error message may have a different meaning and cause in clustered environment.
September 22, 2009 at 8:05 am
Silverfox (9/22/2009)
Timothy.Cloud (9/22/2009)
What does it mean when you find that your SQLAgent service terminated with error 3417?It's the only "odd" event surrounding a period of time when my SQL Server stopped accepting connections.
A simple reboot fixed the issue, but I need to explain to my boss what happened.
Does anyone know what would cause the agent to terminate with error 3417?
it is a service related error, it can occur for various reasons. normally you see more information in the logs or event logs detailing why it failed. a restart of the sql agent should have worked in theory, rather than a reboot.
You have posted the links that I looked at, I didnt post them as it is a generic error and there are various reasons for failure depending on what other information you can get from the sql logs and windows event logs
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply