Orphaned Users for Mirroring setup

• SQL Galaxy

  One Orange Chip

  Points: 29472

  More actions

  October 22, 2011 at 4:15 am

  #250585

  Hi,

  Database user to become Orphaned User by automatically, whenever mirror database to change the Principal database.

  Please suggestion me, how to resolve this issues?

  Thanks

  ananda

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  October 22, 2011 at 5:01 am

  #1398316

  When you create the logins on the mirror server, create them with the same SID as on the principal.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• Perry Whittle

  SSC Guru

  Points: 234013

  More actions

  October 22, 2011 at 8:12 am

  #1398327

  ananda.murugesan (10/22/2011)

  ---

  Hi,

  Database user to become Orphaned User by automatically, whenever mirror database to change the Principal database.

  Please suggestion me, how to resolve this issues?

  Thanks

  ananda

  you can either script the logins from the principal yourself and apply them to the mirror or you could use SSIS to transfer them for you. Either way, as Gail has pointed out the login SIDs must match between the principal and mirror servers.

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉