Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-10-26 : 08:01:42
|
| Doug writes "Hi,For some reason, when we restart our SQL server, the SQL server agent doesn't restart, even though I believe I've checked off the correct setting to make sure that it does. I'm not a SQL DB admin, I've kind of been put into that role because I'm the company's network admin. Any information you could provide would be greatly appreciated.Doug" |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-10-26 : 08:42:28
|
ok a few things to check...go to services...can you start the sqlserveragent there?if yes, check if the startup is automatic or manual, change to automatic  if no, what does the error say?verify if there is permission problem, the sqlserveragent service can be ran as localsystemaccount or a domain account with sysadmin privilege in the sql server (go to enterprise manager and verify under security)let's take it from here and post your finding if it still doesn't start up--------------------keeping it simple... |
 |
|
|
|
|
|
SQL server agent restart