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

  • Expected behaviour, no?

    The connection string specifies ServerName and FailoverPartner. So the app tries ServerName first, then FailoverPartner if unsuccessful.

    The login errors you're seeing are the attempts of your app to connect to ServerName, which fail as it's the mirror and the database are unavailable. The connection then tries FailoverPartner and is successful.