I have a problem with log shipping in SQL Server 2012.
I have tried to configure log shipping between server A and server B. The log destination is on my PC (shared folder). This scenario is working successfully.
Now the problem is when I try to make the logshipping between two servers. I make a shared folder from
INFORTREND. Even when I have changed the permissions, it fails to be executed. The log history of the failure shows:
The last step to run was step 1 (Log shipping backup log job step).
Executed as user: NT Service\SQLSERVERAGENT.
The step failed.
Cannot open backup device '\…\TESTLAGI_20160601082323.trn'.
Operating system error 86 (The specified network password is not correct.)
BACKUP LOG is terminating abnormally.
I don't know what's wrong with it. Is it because the SQL Server log shipping doesn't support a third place to put logs for log shipping?
I have added permission for
EVERYONE, and given it full control. It should be working, because when I use a shared folder on my PC, it works great, but when I use storage machine, it fails.