Post reply

Transfer logins after mirror has been established

  • March 6, 2008 at 9:51 am

    #124256

    Is there a way to transfer security logins between mirrored SQL Server 2005 Servers that do not belong to an active directory domain? I've tried the Microsoft kb article and when I run the sql script I get "The database cannot be opened. It is acting as the mirror." Is there another way to get these logins created on the mirror?

  • March 6, 2008 at 9:57 am

    #786143

    jchamiak (3/6/2008)

    Is there a way to transfer security logins between mirrored SQL Server 2005 Servers that do not belong to an active directory domain? I've tried the Microsoft kb article and when I run the sql script I get "The database cannot be opened. It is acting as the mirror." Is there another way to get these logins created on the mirror?

    You need to create the logins on your mirrored side with the same SID's from the principal.

    First get the SID from the principal:

    SELECT sid FROM sys.syslogins

    WHERE name = 'NameOfLogin'

    Then create your login on the mirror using the SID from above.

    Once mirroring is in place, the objects and their permissions will be mirrored to the mirror. Now to read from those databases, you would have to snapshot the database as you can not read a mirrored database.

Viewing 2 posts - 1 through 1 (of 1 total)

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