September 16, 2010 at 11:58 am
I know this is antique technology but I have a SQL 2000 sp4 instance running on a 2-node Win 2000 cluster. Everything is fine on one cluster node but SQL Agent will not start on the other node. It times out and causes the resources to move back to the first node.
The only related messages in SQLAGENT.OUT are:
SQLAgent$INST1 service stopping due to a stop request from a user, process, or the OS...
SQLServerAgent terminated (normally)
There are no errors in the SQL error log. Only:
SQL Server is terminating due to 'stop' request from Service Control Manager.
The only warning or error in the application event log is:
SuperSocket info: (SpnRegister) : Error 8344.
The only messages in the system event log are about the cluster resources becoming degraded and the SQL Agent resource failing.
thanks for any troubleshooting ideas.
September 16, 2010 at 12:58 pm
can you attach a sqlagent.out file that came from the (failed) start of the troublesome node ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
September 16, 2010 at 1:08 pm
Here is one. thanks
September 17, 2010 at 12:10 am
Strange indeed. According to the sqlagent.out logging it seems sqlagent received a stop request.
[131] SQLAgent$INST1 service stopping due to a stop request from a user, process, or the OS... 2010-09-16 13:50:09 - ? [098] SQLServerAgent terminated (normally)
Are there any jobs scheduled at sqlagent startup time ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
September 17, 2010 at 7:00 am
Nope, I confirmed, no jobs are set to start when sql agent starts.
I think I will try changing the account that sql agent runs under although I don't think that's it. The sql service runs under the same account and it starts cleanly on the node where sql agent will not start.
September 17, 2010 at 7:18 am
I don't think it is an account problem.
If it were, it wouldn't get sqlagent to start in the first place.
Did you enable automatic failback in the cluster group definitions ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
September 17, 2010 at 7:31 am
I have Prevent Failback selected which is the value we use on all our clusters. The thing I can't believe is no errors are logged. There is the SuperSocket info: (SpnRegister) : Error 8344 message but that's a warning about registering the virtual server name in AD. I don't think that is related to sql agent not starting.
September 17, 2010 at 7:47 am
as per http://support.microsoft.com/kb/303411
"Error 8344 is equal to insufficient permissions to perform the registration operation."
This doesn't apply for sqlagent.
Did you try changing the service account and putting it back to the current one ?
Off course using the procedure ms prescribes :
- http://support.microsoft.com/kb/283811
- http://support.microsoft.com/kb/254321
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply