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:
- Is there any problem with sharing the account at server A
- 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.