Tuesday, March 6, 2012

account used to run SQL Server services

I'm attempting to follow the best practice of running the SQL Server
services under a local windows account with "just enough priviledges"
without assigning it as an admin. I've read numerous places to not use the
Local System Account as well.
In Books Online, the section titled "Troubleshooting MSSQLServer or
SQLServerAgent Services User Accounts" has the list of rights the account
must have to make the services work. Is there a utility that you can point
at a local windows account, and it will assign the appropriate rights for
you? I missed my opportunity to do this when installing SQL Server
initially.
Thanks in advance.
MarkI don't know of a utilty.
You may find these links helpful:
http://whidbey.msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_overview_6k1f.asp
http://whidbey.msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_afterinstall_4p0z.asp
--
Keith
"Mark" <field027@.idonotlikejunkmail.umn.edu> wrote in message
news:%238GNYFk$EHA.3924@.TK2MSFTNGP15.phx.gbl...
> I'm attempting to follow the best practice of running the SQL Server
> services under a local windows account with "just enough priviledges"
> without assigning it as an admin. I've read numerous places to not use
the
> Local System Account as well.
> In Books Online, the section titled "Troubleshooting MSSQLServer or
> SQLServerAgent Services User Accounts" has the list of rights the account
> must have to make the services work. Is there a utility that you can
point
> at a local windows account, and it will assign the appropriate rights for
> you? I missed my opportunity to do this when installing SQL Server
> initially.
> Thanks in advance.
> Mark
>

No comments:

Post a Comment