Transaction Log Shipping Permissions - Help

[AccessUser22]

Hi,

We are in the process of trying to set up a transaction log shipping operation and are currently having issues with the copy job. The primary server backup job runs fine and then the copy job which runs from the secondary(copy) server is not able to copy the backup file from the backup folder on the primary server. I get the following error:

An exception occurred: Cannot open backup device (file location of primary backup)...Operating System Error 5(Access Denied).

I read that in order for the copy job to be successful, the proxy account of the copy job (the SQL Server Agent on the secondary (Copy) server instance) must have read permissions to the backup directory located on the primary server.

We are a little confused as to how we are supposed to assign rights for the SQL Server agent on the secondary server to the backup folder located on the primary machine.

Any advice or tips are appreciated. Thanks for your help.

 

[mrdenny]

First you need to make sure that everything is running under domain accounts. You then need to make sure that the folder with the backup files has access via the NTFS permissions to the folder, and all folders above it up to the network share that you are using to access the folder.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com