| Computers Forum Index » Computer - Databases - MS SQL Server » Installing sql server 2008... |
|
Page 1 of 1 |
|
| Author |
Message |
| akkha1234 at (no spam) gmail.com... |
 Posted: Tue Jun 09, 2009 4:27 pm |
|
|
|
Guest
|
I am trying to install sql server 2008 with "best practices". One of
the recommendation from Micorsoft is to use domain user account with
the minimum amount of privileges as service account. Is there any
ramifications and downside to this kind of installation? Thanks for
any advise |
|
|
| Back to top |
|
|
|
| Mike McNeer... |
| Posted: Wed Jul 29, 2009 9:25 pm |
|
|
|
Guest
|
Well the reason I would use a domain user account as opposed to the
local system account would be if you need to access resources or
servers outside of the server. i.e. Let say you want to restore a
database backup from another server without physically moving it. If
the domain account has authority to the share or device you could
restore directly. This is just one of many examples of why you would
need to do that. As long as you assign any appropriate permissions to
the domain account needed by Sql Server I really can't see any down
side to using a domain account as opposed to the LOCAL account.
Mike
On Jun 9, 11:27 am, "akkha1... at (no spam) gmail.com" <akkha1... at (no spam) gmail.com> wrote:
Quote: I am trying to install sql server 2008 with "best practices". One of
the recommendation from Micorsoft is to use domain user account with
the minimum amount of privileges as service account. Is there any
ramifications and downside to this kind of installation? Thanks for
any advise |
|
|
| Back to top |
|
|
|
|
