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 |
|
dos_net_pass
Starting Member
3 Posts |
 Posted - 2009-08-25 : 04:53:54
|
| SQL 2005 Books Online states that for the Auto-Restart functionality of SQL Server Agent to function the SQL Server Agent user account must be a member of the Administrators local group.For security reasons we utilise a user account with lower priviliges.Is it possible to use a user account that is not a member of the Administrators local group and still have the auto restart capability of the SQL Server Agent?I have come across listings of the Windows permissions, registry key access permissions and NTFS permissions that the SQL Server Agent user should have. If these are given would the low privilige account regain 'Auto-Restart' ability? But by giving these to a low privilige account am I not effectively rebuilding an 'Administrator' privilige account?? |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2009-08-25 : 05:51:16
|
| Go to sql Server Configuration Manager...On left select Sql Server 2005 Services... on right side right click on Sql Server Agent and select properties ... On first tab select user and password for service to start and on second tab (Service) change start mode to AUTO------------------------------http://connectsql.blogspot.com/ |
 |
|
|
|
|
|
SQL 2005 Server Agent Auto Restart