I have setup a nice log shipping solution on SQL 2000 Standard. Instead of using Linked servers (I couldn't get them to work using NT authentication) I used DTS which has been working fine. However, the service account on the live server is a server administrator on the recovery server. What I would like to do is trim it's rights down to the minimum needed. The problem I face is that if I just grant the user execute on the stored procedures it needs to run (stored in an admin database) I get an error from DTS saying that 'Server user 'DGASStratusServer' is not a valid user in database 'Snap'' I can't add the user to the datbase because it is in warm stand-by so the only option is to make the user server admin. Is there a way I can fix this perhaps? The server is used for other things and I dont want the account to be a server administrator.