Q. How to create users on secondary standby database in Log shipping ?
Answer: You can create the user on the primary and the log shipping will take it over to the secondary. Make sure if you’re also creating a login in Secondary Server that you explicitly specify the SID.
|You can create a user without a login in SQL Server 2005 and newer. However, you can see these steps to simplify it for you:
1. Create login on production server
Note: (Reason to follow above additional steps than regular process)
|Existing users can query the log shipping secondary.
You cannot create new users in the secondary because that’s a change and the database is read-only (no changes permitted)