July 8, 2003 at 7:27 am
When the server fails over, the SQL Service restarts, but the agent does not. When I go the Service Properties in EM the option is grayed out. When I go to the Services MMC both MSSQL and the agent service show as manual. MSSQL is started, but the agent is not.
Also, in cluster administrator the Agent is in the same group as the rest of the SQL stuff and lists as dependant on the SQL service, and the restart option button is selected.
Finally the error logs show no errors. I can manually start the service with no problem. It seems to me that the failover is not even trying to failover the Agent Service.
Any help on this topic would be appreciated.
July 8, 2003 at 1:17 pm
If SQL Server Agent service is grayed out in EM, I'm guessing it might be a permissions issue. Did you set the service permissions as administrator on the domain?
-SQLBill
July 9, 2003 at 1:32 am
this option is to be managed using cluster administrator - sqlserveragent resource - properties - advanced. Check its settings.
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
July 9, 2003 at 6:23 am
quote:
What exactly you did, before your SQL agent goes down?
I paused the only node I have (I have not yet instelled the second node) on the cluster to install NAV.
quote:
Did you initiate the fail over at the System files disk? Also what is the configuration you setup if the system files disk fails do you want your sql server services and the IP address to Failover or you want the server to show its down?
Services should move to the second node (when it becomes abaliable).
I have two groups:
One has the Quorum disk, Cluster Name, VIPA, and DTC
The Other has the Data Drive, SQL's VIPA, SQL's Netowrk Name, SQL Service, Agent, and Fulltext service.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply