Post reply

create users in a read-only database

  • 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.

  • 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.

  • 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

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

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