Post reply

New Installation - Service Accounts

  • August 24, 2012 at 4:27 am

    #260542

    I am installing SQL Server 2008R2 Standard. This is a non-clustered installation on Windows Server 2008.

    I've read that ideally you should have a separate account for each service.

    This may be a stupid question but do these accounts need to be an AD Domain account or can I create local Server accounts for each service.

    If I can create the local accounts, what are the pros and cons?

    thanks

  • August 24, 2012 at 5:57 am

    #1529671

    thunderousity (8/24/2012)

    ... do these accounts need to be an AD Domain account or can I create local Server accounts for each service.

    If I can create the local accounts, what are the pros and cons?

    Domain account is better.

    Domain account is useful while taking backup to a shared folder, replication, log shipping, etc.

  • August 24, 2012 at 7:50 am

    #1529739

    Why create a local account? If you are in a DR situation, you will need to recreate things instead of using the same account.

    Use a domain account. No rights at all. Let the SQL installation program set the rights.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply