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 |
|
allan8964
Posting Yak Master
249 Posts |
 Posted - 2012-02-20 : 09:37:09
|
| Hi there,Who can tell me how to grant Server Agent Service to an account?Thanks in advance. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2012-02-20 : 10:19:45
|
Are you using a proxy account?
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
allan8964
Posting Yak Master
249 Posts |
Posted - 2012-02-20 : 11:32:31
|
| Yes, is there any difference between proxy and non-proxy account?Thanks. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-02-20 : 16:06:17
|
| start/run/services.mscdouble-click SQL Server Agent. Go to log on tab.Make sure account has permissions on any resources SQL Agent Jobs will touch. |
|
|
|
allan8964
Posting Yak Master
249 Posts |
Posted - 2012-02-20 : 17:13:58
|
| Thanks but this is only for one account. I need to grant three of them. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-02-20 : 17:32:08
|
| What is it exactly that you're trying to do? There is only one service account per service.Or do you mean msdb roles |
|
|
|
|
|
|
how to grant Server Agent permission?