SQLagent does not start?
I have a strange thing going and can't figure out where to look.
I have is a SQL-agent that only starts manually but not when under control of VCS. When VCS starts the service it changes the state to "Starting". After a couple of seconds it stops and generates an error messages.The rest of the servicegroup (also the SQLServer service) works just fine under VCS.
Event Type: Error
Event Source: SQLAgent$SAPSQL07
Event Category: Service Control
Event ID: 103
Time: 8:14:49 AM
SQLServerAgent could not be started (reason: Unable to connect to server 'XXXXXXXXXSQL07\SAPSQL07'; SQLServerAgent cannot start).
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
This also happens on one of the two nodes.???
I'm using SFWHA for windows on a W2K3 SP2 enterprise x64 server and have installed SQL2005 instances