create users in a read-only database

• Jerry Tienter-162701

  Say Hey Kid

  Points: 694

  More actions

  August 27, 2008 at 11:30 pm

  #191929

  In a log shipping environment how do I create a new user on a read-only database?

  Thanks.

• Skandalis

  Hall of Fame

  Points: 3517

  More actions

  August 28, 2008 at 12:08 am

  #864134

  You'll have to create that user in the source database.

  Should it be a SQL login - Be sure to create it on the log shipped server with the same SID as the source.

  Shout if you need more info.

• Patti Johnson

  SSCertifiable

  Points: 7054

  More actions

  September 2, 2008 at 7:16 am

  #865969

  I was wondering is there a script to automate this? I would like to automate so that I don't have to keep on top of new sql logins.

  Thanks.

  Patti