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

Popular posts from this blog

google chrome - Developer tools - How to inspect the elements which are added momentarily (by JQuery)? -

angularjs - Showing an empty as first option in select tag -

php - Cloud9 cloud IDE and CakePHP -