Log shipping a sql user account

  • Is there a reason why my NT accounts logship with no problem but SQL accounts do not? This is SQL 2000.

  • I may not completely understand the question, but I don't have that issue when log shipping.  All of my target server logins are already setup (in master).  Any permission changes on the source database make to the target database just fine.

  • How did you setup the accounts on the target server? Does the sid have to be the same on the source and destination in order for this to work?

  • User accounts used to start the agents on both machines has to have privileges to read & write to the share folder where Tr logs are stored...

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

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