I have implemented log shipping and now I've been asked to add a new sql server account.
I added the account to the primary.
Then I used the sid from primary to create the same 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?