October 5, 2015 at 2:08 pm
Hi all,
Getting the above error when trying to set up log shipping via the wizard in SSMS. Primary / Secondary servers are on the same domain, accounts used are NT Service\SQLSERVER and NT Service\SQLSERVERAgent on both servers. I use network paths everywhere. The first step in the wizard succeeds then it fails with the message:
Cannot open backup device '\\SQL2\BACKUP\DB.bak'. Operating system error 5(Access is denied.).
RESTORE FILELIST is terminating abnormally. (Microsoft SQL Server, Error: 3201)
Both folders are shared with 'Everyone' and added 'Everyone' under Security with Full control. What could be the problem? Thanks
October 6, 2015 at 12:34 am
You'll need to add the computer account to the share and ntfs permissions lists
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 6, 2015 at 11:25 am
Thanks for your response. What do you mean by "computer account"? Do I have to create a new domain account on the Secondary and assign folder permissions on the Primary server for this account?
October 7, 2015 at 4:57 am
kiril.lazarov.77 (10/6/2015)
Thanks for your response. What do you mean by "computer account"? Do I have to create a new domain account on the Secondary and assign folder permissions on the Primary server for this account?
Since you're running the sql server services under the pseudo accounts NT Service\SQLSERVER and NT Service\SQLSERVERAgent this changes the way authentication works. The 2 services will authenticate on the network as
Domain\Comptername$
It is this account that should be granted access permissions to any shares\NTFS locations
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 26, 2017 at 12:08 pm
Just a note that in Server 2012 R2 at least, the normal Windows "Share..." dialog does not allow you to search for or add Computers to the share. You have to go under "Advanced Sharing..." to be able to add "Computers" in the Object Type list when using the "Select Users..." dialog.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply