SID Mismatch RRS feed

  • Question

  • What are the resons for SID mismatch in SQL Server 2016 (AlwaysOn)?

    Recently we have migrated DB from 2008 to 2016 and i have micrated all users with SP_Revlogin.

    Everything working fine from past 1 month, but recently i found that user is not able to access DB after failover.

    When i verify the user is not mapped to DB, found that SID is Missmatch.

    What could be the reason?

    Monday, June 24, 2019 5:38 PM


All replies