Home > IT Answers > Database > SQL Server 2005 log shipping network pass thru security
Jando999
5 pts.
 SQL Server 2005 log shipping network pass thru security
SQL Pass Through Query, SQL Server 2005, SQL Server 2005 log shipping, SQL Server Agent, SQL Server log shipping
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 ?

Software/Hardware used:
ASKED: March 18, 2009  2:16 AM
UPDATED: March 18, 2009  1:53 PM
RELATED QUESTIONS
Answer Wiki:
Setup a proxy for the local account and have the job step which does the file copy run under this proxy account. That "should" get it working.
Last Wiki Answer Submitted:  March 18, 2009  2:30 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _