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 |
|
under2811
Constraint Violating Yak Guru
366 Posts |
 Posted - 2008-04-18 : 00:51:31
|
| Hi folks!!I am new to installation of SQL Server 2005..I wanted to know while selecting Service Account Screen why Avoid running SQL Server Agent as the Local System account.????T.I.A |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-04-18 : 03:36:15
|
| Local system has too many permissions. The standard security recomendations are to use accounts that have the minimum permissions necessary to do what is needed.Local system is administrator on the local machine and hance has permissions to do anything.The second reason is that local sysem ONLY has permissions on the local pachine, not anywhere else on the network. So if you need SQL agent to access other server, file shares, etc it won't be able to.Make any sense?--Gail Shaw |
 |
|
|
under2811
Constraint Violating Yak Guru
366 Posts |
Posted - 2008-04-18 : 05:51:37
|
| Does make senseRegards |
|
|
|
|
|
|
Avoid running SQL Server Agent as the Local System