I have a need to setup log shipping across two networks that have no domain relationship. They are two separate work groups. I have been through every tutorial online to get this working but I am having an issue with what I believe is the permissions across the two network/servers.
The actual setting up of the log shipping is fairly simple, I understand the logic. I can connect between the two SQL servers using IP address port 1433 (I know this port is not secure I am just using it to get the log shipping working), so I can open databases from both sides no issues. So I don’t think there is any firewall / connection related issues.
I have setup new window accounts on each server called SQLSVC with the same passwords and set the SQL service Agents on both machines with these new accounts (restarted the services also). I have given full read and write access to the two directories on each server that will hold the SQL logs to these new accounts. On the primary server ‘A’ I have set the log folded I created as shared with full permissions given to the local SQL service agent. I can allocate any additional permissions I need but I have even added (the everyone) account and given that full permission just to test.
Where it is falling over is when I do the ‘Save Log Shipping Configuration’, it backs up the database on server ‘A’ ready to restore on server ‘B’ and is at the restore step I get this error.
The SQL on both servers is exactly the same version. SQL 2008 R2
What am I missing? Any help would be really great thanks for looking.
Restore backup to secondary database ….. ERROR….
TITLE: Microsoft SQL Server Management Studio
SQL Server Management Studio restore database ' testdb '
An exception occurred while executing a Transact-SQL statement or batch. (SqlManagerUI)
Cannot open backup device '\WIN-UC7TSJO3UEM\Log shipping\testdb.bak'. Operating system error 53(failed to retrieve text for this error. Reason: 15100).
RESTORE FILELIST is terminating abnormally. (Microsoft SQL Server, Error: 3201)