Database Mirror Login SID for ##MS_PolicyEventProcessingLogin##

• Express12

  SSCoach

  Points: 18514

  More actions

  July 17, 2013 at 5:51 am

  #276116

  In William Thier's excellent SSC article "Configuring Database Mirroring" ( http://www.sqlservercentral.com/articles/Database+Mirroring/72009/ ) he mentions...

  "If the mirrored database contains non domain users, SQL_LOGINs should be created on the mirror server with the same sid as the corresponding login on the principal server"

  We have a Login on both our PRINCIPAL & MIRROR, created by the SQL Server 2008 R2 E'prise installation, called ##MS_PolicyEventProcessingLogin## --- with different SID's.

  Does this Login need to be sync'd on the MIRROR w/ the same SID?

  BT

• arnipetursson

  SSCertifiable

  Points: 6557

  More actions

  July 17, 2013 at 10:42 am

  #1633383

  Is this login a user in the mirrored database(s)?

  If not, then it does not need to be synced.