1

Log shipping fails with the below error. Sql agent on secondary server has access to the folder and files in security. It is not a firewall issue. I created the jobs using the LS scripts as it fails through GUI.

I have done it before on a different server where there were several LS databases. This is a new primary and secondary server and not sure what I am missing. Thanks for the help

***** Error: Access to the path '\\sqlp\R$\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\Database' is denied.(mscorlib) ***
----- END OF TRANSACTION LOG COPY     -----**
  • 2
    The R$ share is only accessible by administrators. Therein lies your problem, with almost 100% certainty. You should create a share on the Backup folder with security that allows the SQL Server service account write access. – Max Vernon Dec 3 '13 at 15:54
  • Yes that was it. I gave sa account admin rights on the server. Thank you for your help and time! – knahs Dec 11 '13 at 14:48
1

I've ran into this same problem! As Mr. Vernon stated, the account needs admin access to the server. However, that is not the recommended way of providing access to the service account, especially if you're to follow the "least privilege" security mantra.

Instead, perform the following:

  • Create an appropriately named security group
  • Add the SQL Server Agent account to the group
  • Create a shared folder on the server you're shipping the logs to
  • Assign the newly created security group with Modify permissions to the folder

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.