SQL Server agent can't start

[MarkGreen]

When I right click on SQL server agent and click start i get the message "An error 5- (access is denied) occured while performing this service operation on the SQLServerAgent service"

I am logged in as an admin user who has all the possible server roles.

Any ideas?

 

[MaffewW]

error 5 is I think a general message regarding logons/security. Check your SQL Server Agent service startup account. It should be a domain account, make sure no one has changed the password for the account, or locked it out. Can the server 'see' the domain for which the sql server agent account is a member (can you log on to it or ping the PC's on it)

Matt

Brighton, UK

 

[MarkGreen]

The password is correct for the user. I've just tried using a different admin account and same thing happened.