Add additional user to SQL 2005 Log Shipping Database

  • I have a Log Shipping database that is coming from a vendor. We are wanting to let users access the Log Shipping database to create custom reports. The problem that I'm having is that can not add a new user to the Standby/Read-only database. Does anyone have a way to do this?

  • If you want to keep the database in standby you will have to have the vendor add the users to the source database.

  • Thanks for the reply back.

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

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