Post reply

best practice - seperate windows accounts for sql services?

  • January 4, 2018 at 4:37 am

    #341558

    Morning all, 

    I'm trying to decide if I should have separate windows accounts for my SQL Server, Agent, SSRS etc. services.  (As in separate accounts for the services on 1 instance),

    I guess given that they need different ACLs / NT rights, it would be better practice to have different accounts.  I'm just wondering if it gets a bit over granular / over the top?

    Looking for advice based on your experience / sops / thoughts if possible.

    Thank you.

  • January 4, 2018 at 4:43 am

    #1974419

    Simple answer, yes separate accounts is the best way to go.

    ...

  • January 4, 2018 at 4:43 am

    #1974420

    Also when amending windows permissions for a SQL service account - do I need to restart for the changes to take effect?

  • January 4, 2018 at 4:51 am

    #1974421

    snomadj - Thursday, January 4, 2018 4:43 AM

    Also when amending windows permissions for a SQL service account - do I need to restart for the changes to take effect?

    No you shouldn't need to restart.

    Thanks

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

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