InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 21:13:40 GMT20http://www.sqlservercentral.com/Forums/Topic1076972-291-1.aspxIts also a good idea to disable the login at the source (if possible) to prevent accidental access thereThu, 26 May 2011 16:49:40 GMTMysteryJimbohttp://www.sqlservercentral.com/Forums/Topic1076972-291-1.aspxCoozie has duplicated posted [url=http://www.sqlservercentral.com/Forums/Topic1115845-291-1.aspx]here [/url]but it is good forum etiquette to post your resolution to an issue to help others.Thu, 26 May 2011 16:09:48 GMTgeorge sibbaldhttp://www.sqlservercentral.com/Forums/Topic1076972-291-1.aspxWould you be able to let me know what you did to fix this? I have implemented log shipping and now they want me to add a new sql server account. I added the account to the primary.Then I used the sid from primary to create the account on the secondary master database.Problem is: The user account doesn't show up in the secondary databases.How do you add new accounts to the primary and get them to show up in the secondary?Thanks,MarkThu, 26 May 2011 14:00:34 GMTCooziehttp://www.sqlservercentral.com/Forums/Topic1076972-291-1.aspxI figured it out.Fri, 11 Mar 2011 09:31:17 GMTklittlejohnhttp://www.sqlservercentral.com/Forums/Topic1076972-291-1.aspxWe just implemented log shipping and use the secondary DB server for reporting. How can I add the existing users on the primary server to the secondary DB so they can access the database. Do i need to create a new account on the primary server, get the SID and create a new account on the secondary server with the same SID or can i migrate the existing accounts over to the secondary server? Help is greatly appreciated and thanks in advance!Fri, 11 Mar 2011 09:08:06 GMTklittlejohn