SQL Server Log Shipping – Access to Folder is Denied

log-shippingsql server

I am trying to log ship from server A to B. I have done everything to configure log shipping but when I try to run the job at Server B while copying a backup from server A, ikt gives me an error:

can not access the path (Server A backup folder name) access is denied.

I have shared backup folder at server A with admin account moreover with Everyone. I also tried to change SQL Server agent config and use option (this account) in properties and fill my system account.

Please help me to fix this problem and explain a little like:

  1. Is there any problem with sharing the account at server A
  2. Do I need to change my SQL Server Agent service account and how?

Let's say at server A there is a folder backup in E drive and there is a folder restore at server B in E drive. I am trying to login to SQL Server through Windows service credential in server A.

Public ip for my two servers is 10.201.4.111 and 10.201.4.112 and my service accounts are local system, which are built in accounts.

Best Answer

thanks all for answers..solved my problem created two user accounts with the same name and same password in each server and then used them in sql agent services under "this account" option

Related Question