Hi,
I have worked with this issue before, but still got stuck here. I understand the why part, but nevertheless had hard time to make it work.
I installed a new SQL server 2012 to a default instance to a new windows server 2012 R2.
Then copied a production full backup into C:\backup
But running restore command within SSMS got
Cannot open backup device 'C:\backup\db_backup_2016_02_17_221000_7225667.bak'. Operating system error 5(Access is denied.).
Under SQL configure manager, the sql server service account is running as NT Service\MSSQLSERVICE,
But I have hard time to add it to the C:\backup folder. My personal account is in admin group. I should be able to change the permission, but.
Should I reinstall sql or change it to run under one of the built-in account? and which one is easier to work with under this windows environment?
Thanks!