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 |
|
Hariarul
Posting Yak Master
160 Posts |
 Posted - 2007-08-28 : 09:19:07
|
| Hi all,Please let me know what specific privileges an user account needs to be used as LOG ON AS account for SQL Server Agent in SQL Server 2005.Does the account needs to me in the domain administrator group?Thanks,Hariarul |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-08-28 : 11:46:31
|
| Local admin group is fine. It does not need to be and should not be in the domain admin group.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-28 : 21:03:21
|
| Should be in sysadmin role. |
|
|
|
|
|
|
SQL Server agent - Account privileges.