Home Forums SQL Server 2008 SQL Server 2008 High Availability Client side automatic reconnect fails after DB failover when SQL Server on non-default ports RE: Client side automatic reconnect fails after DB failover when SQL Server on non-default ports

  • I'm aware of this ... but the application can't connect to the mirror just by its name - when the port information is missing ... and this is in my opinion the root cause. When I failover the database to the secondary server, on the client computer I can see attempts for connections to the secondary server but ON THE DEFAULT SQL TCP PORT 1433 (via TCPView). The "only" question is why aliases and/or default SQL port don't work.