Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2002
    Posts
    162

    Unanswered: Creating users in Standby mode

    Hi,

    I have a SQL Server 2005 Database that is in Stand-by mode (I apply 5 transaction log files to it everyday). I need to be able to add users to read the DB (not write) but SQL Server won't let me do it, giving me this error >>

    Msg 3906, Level 16, State 1, Line 1
    Failed to update database "Easygrants_RBI" because the database is read-only.


    What can I do to grant my users access to the DB to run queries??? can I do anything with the Guest user???

    I need help

    Thanks

    'Wale

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    If you add the users to the source database, the transaction log backup will carry those users into the standby database. You can then remove the logins (but not the users) from the source system to prevent unwanted access.

  3. #3
    Join Date
    Mar 2002
    Posts
    162
    Crap, I was afraid someone was going to say that. I don't have the power or authority to add users to the source db. So there are no backdoor solutions huh?

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Well, you could create logins on the standby server that have the same SIDs as existing users, but that starts getting into iffy ethical territory, if this is not really your data.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •