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
arnipetursson
SSCertifiable
Points: 6557
More actions
July 24, 2014 at 2:59 pm
#1732209
Agree with Gazareth.
The app will try Primary first. When it is acting as the mirror, the login attempt cannot open the mirror database, and thus fails.