Home Forums SQL Server 2008 SQL Server 2008 High Availability Automatic Mirroring fail over and see Login failed errors in error log of current Mirror server RE: Automatic Mirroring fail over and see Login failed errors in error log of current Mirror server
Gazareth
One Orange Chip
Points: 27737
More actions
July 18, 2014 at 9:04 am
#1730658
Perry Whittle (7/18/2014)Orphaned users on the mirror.Check sids between the primary and mirror
Perry Whittle (7/18/2014)
Check sids between the primary and mirror
Perry, this is happening on the primary server when it's acting as the mirror; all the databases are in the restoring state, can't be orphaned logins.