How to fix error "SQL Server Agent stopped automatically"? -
i'm using sql server 2014 , having problem.
in task manager, on services tab, found sqlagent$villbe_sqlserver (villbe computer name), right click , start.
it started and... stopped after 1 second.
then, open services.msc, , start sql server agent (villbe_sqlserver). it's working.
after 30 seconds, stopped automatically. when click start again, said that:
the sql server agent (villbe_sqlserver) service on local computer started , stopped. services stop automatically if not in use other services or programs.
last, right click sql server agent, choose properties, set start type automatic , reboot pc.
when reboot done, sql server agent still stopped
some other services:
sql server browser - running - automatic (start up) sql server (sqlexpress) - cannot start within warning: **windows not start sql server (sqlexpress) on local computer....error code 17058.**
can give me anyway fix problem?
thank you!
if running sqlexpress, sqlagent doesn't run. if running sql2008 or sql2012, changed sql sa password. can change sql service authentication network service local system, start service manually.
Comments
Post a Comment