I am trying to setup log shipping between 2 database which are in the same network but different server machine. I mean one is on 192.168.0.2 and the other one is on 192.168.0.15. I setup the log shipping and the folders on the respective servers for backup and copy of the backup file. But it seems the secondary server does not have access to the folder on the primary server where it needs to copy the backup file in its own folder. How can i setup this authentication. I prefer to use the database authentication rather then windows as my network is a simple workgroup and not using Active directory or domain setup. Please help.
Date 9/21/2015 11:50:38 AM
Log SQL Server (Current - 9/21/2015 11:54:00 AM)
Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. [CLIENT: 192.168.0.2]