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