I have a need to ship logs to a remote secondary server that is in a different domain and without domain trusts.
I have configured the SQL Agent on each machine to use a local account (.SQLAgent) with the passwords the same on both machine.
The secondary machine can read the network share that contains the backup, however the Copy job Fails.
IS the above SQL Agent account configuration correct for network pass thru security ?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!