title: Creating Users on secondary server in log shipping
body: <p>I have a production Server say <code>ServerA</code> I have setup log shipping to <code>ServerB</code> which is left in read-only mode. The purpose of this log shipping is to lower the load on production server for some expensive queries (painful reports). </p>
  
  <p>Now if I have to create some logins using our domain accounts. I cannot do this because the secondary database is in <code>standby mode</code>. </p>
  
  <p>I thought if I create these logins on Primary server it will be copied over to secondary server then the logs are restored there but this isnt the case. </p>
  
  <p>I have done a lot of research online finding a way around to this. I found the following resources for this. I tried every method suggested in this articles but none of them seems to work. </p>
  
  <p>1) <a href="http://madebysql.blogspot.co.uk/2010/03/how-to-createadd-new-database-user-to.html" rel="nofollow"><code>Log Shipping in SQL Server 2008 R2 for set BI on replicated database</code></a></p>
  
  <p>2) <a href="http://support.microsoft.com/kb/246133" rel="nofollow"><code>How to transfer logins and passwords between instances of SQL Server</code></a></p>
  
  <p>3) <a href="http://blogs.msdn.com/b/sqlserverfaq/archive/2009/04/13/orphaned-users-with-database-mirroring-and-log-shipping.aspx" rel="nofollow"><code>Orphaned Users with Database Mirroring and Log Shipping</code></a></p>
  
  <p>Has someone experienced the same issue? what did you do? Is there any way around for this issue? Any suggestions any pointer please.</p>