SQL Server Agent failed to start -
i have aws sql server 2008 r2 running , related service such sql server browser , running. sql server agent disabled (probably security reason), now, periodical backup service needs sql server agent , running, so, attempted start agent, first of course set manual, however, failed start err msg effect "some services automatically stop...", meaningless.
what need agent , running?
thanks.
the sql server agent needs variety of things run. chances of them not set up. verify account used run sql server agent , make sure has following permissions in local security policy:
- bypass traverse checking
- log on batch job
- log on service
- replace process level token
you might need make member of sysadmin role.
Comments
Post a Comment