ananda.murugesan (12/6/2012)
Thanks for reply..I try to created new user & login on the secondary server instance, but still facing same issues...not able to create new user on the standby read-only daabase
Error msg
Failed to update database "SALEPROD" because the database is read-only. (Microsoft SQL Server, Error: 3906)
The users are NOT created on the secondary standby database, you must create them on the primary first. The log shipping process will then apply the new users to the standby database.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉