Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
saran_d28
Starting Member
36 Posts |
 Posted - 2011-05-17 : 08:37:29
|
| I have configured logshipping from ServerA(primary) to ServerB(Secondary).1) The Backup job in serverA is working fine2) The restore job in ServerB is working fine.3) The copy job in serverB is getting failed. The error messages "Login Failed; Invalid username and password".4) Both server sqlservices and sqlserveragent services are running in same account (Windows Administrator). Both machine passwords are same (windows administrator password)5) I am able to copy the file from ServerA to ServerB using xp_cmdshell command exec xp_cmdshell 'copy ServerA\backupfiles ServerB\copyfiles'6) Full permission given to the both folders.7) Both servers are not in domain but both are in same workgroup.I tried to resolve the problem for last 2 weeks.Please adivise |
|
|
|
|
|
Log shipping copy job not working