Monday, March 12, 2012

mssqlserver account

What account should run mssqlserver and sqlserveragent.
Should it be a local account or a domain account?
Thanks,
MTI like using a Domain account when there may be multiple servers because it
is easier to share file permissions etc... If there is only one server it
doesn't much matter.. If you wish to use mail integration for SQL Server
you may wish to use multiple domain accounts, since email is connected to
the login account - if you wish to separate the email for each server...
The Domain account should have limited permissions (as doc'd in BOL.)
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"mt" <miketownsend33@.yahoo.com> wrote in message
news:028601c37775$9fe611c0$a001280a@.phx.gbl...
> What account should run mssqlserver and sqlserveragent.
> Should it be a local account or a domain account?
> Thanks,
> MT

No comments:

Post a Comment