Transact log shipping not working

  • I am able to create and successfully run the 1st transact log shipping wizard and it finsihes and creates the database on 2nd server and creates all the job, but this is where It ends. the main server still does it thing backing up the logs and putting htem in the share drive, but the second server is not able to run its jobs for copying and backing up becuae I start getting this error on the system.

    Login failed for user 'svc.?????.ngmn'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors

    I have searched alot on this but can't find anything to do with Transact logg shipping and sql jobs. Please Help.

  • What does the copy/restore job histary say?

    Does the SQL Agent service account has read permission to the share?

  • From memory (which is normally wrong) I think that error is related to Kerberos/Delegation.

    Dan

  • create a service account if you have already one, then go to the backup folder (in primary) and copy (secondary) and right click it and go to property and give permission to the service account.

    This should work. if not post it here again.

  • i got it figured out it was a issue of the account not having access on the share, NTFS persmissions where not enough I had to give them access to the share.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply