April 11, 2016 at 10:20 am
What are the options to provide sql server running on Local System accounts to access UNC path for scheduling backups without changing sql server service accounts to a domain account.
Please share your thoughts.
Thanks!
April 11, 2016 at 10:42 am
Access to the UNC path are going to be at the File system level on the target/share.
What are your service accounts?
Configure File System Permissions for Database Engine Access
April 11, 2016 at 10:44 am
SQL service is running under Local System Account.
April 11, 2016 at 10:59 am
try granting access to the computer name
April 11, 2016 at 1:29 pm
I don't think Local System is going to work. I have had to use Network Service in order for that to work. Better overall is a domain account that can be more explicitly controlled. But I do not think that simple Local System can access a file share.
April 11, 2016 at 2:07 pm
give full permissions to computer name on that UNP path folder
April 13, 2016 at 11:21 am
thank you
April 13, 2016 at 11:22 am
thank you
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply