January 10, 2017 at 9:48 am
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?
January 10, 2017 at 9:55 am
If you make the change in SQL Server Configuration Manager, all the permissions will be assigned automagically.
John
January 10, 2017 at 9:56 am
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply