ananda.murugesan (12/6/2012)
I have doubt..
I think if this didn't work as designed Microsoft would have known about it by now 😉
ananda.murugesan (12/6/2012)
Log shipping process have been configured on the primary database also transaction logs apply to secondary database instance, then after create new db user in primary instance then how it will be transfered to secondary database for connecting report module.
Ok, let me explain a little
The creating of all database users must be carried out on the primary instance first, the log shipping processes then ship the logs to the secondary. During a restore the log containing the action
CREATE USER ........
is applied to the secondary database.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉