Permissions for a new Service Account

• BobbyTables

  SSC-Addicted

  Points: 493

  More actions

  January 10, 2017 at 9:48 am

  #333396

  I would like to change the service account running SQL to be something that has access to some network shares so it can copy backups there.

  so say i create mydomain\SQLServiceAccount, and we grant it access to the backup server.

  on the server itself, how do i make sure it has access to the right folders for SQL Server? like the data and Backup folders under Program Files?

  do i have to add it explicitly?

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  January 10, 2017 at 9:55 am

  #1921660

  If you make the change in SQL Server Configuration Manager, all the permissions will be assigned automagically.

  John

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737598

  More actions

  January 10, 2017 at 9:56 am

  #1921661

  John Mitchell-245523 (1/10/2017)

  ---

  If you make the change in SQL Server Configuration Manager, all the permissions will be assigned automagically.

  John

  Do this. Do not try to set these yourself.

  Create a domain account, add it in SQL Configuration Manager as the service account. Grant additional file share permissions as needed, but I'd say use a group in AD, not changing the user permissions.