Post reply

Grant User Access to a Read-Only Database

  • April 23, 2008 at 6:29 pm

    #94184

    Hello,

    I have ServerA with Log Shipping to ServerB which is therefore read-only - Need to give user access to ServerB.

    What I am doing is giving user access to ServerA and wait for the login to be sent to ServerB via Log Shipping. Once it makes it to ServerB - I can see the user in the particular database in ServerB but user is still unable to access the database on ServerB.

    Thanks

  • April 24, 2008 at 7:27 pm

    #806951

    The database and its security will be carried over, but the login (which is at the server level) will not. Likely you will need to add the login to server B.

    EDIT: If it's a SQL Server login, you will want to recreate it with the same SID. If it's a Windows login (or Windows group), this is automatically handled.

    K. Brian Kelley
    @kbriankelley

  • April 24, 2008 at 7:42 pm

    #806954

    Can you please tell me how to add the users with the same SID?

    I would really appreciate it.

    Thank you in advance.

  • April 24, 2008 at 8:48 pm

    #806956

    Documented here: http://msdn2.microsoft.com/en-us/library/ms189751.aspx

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply