Home Forums SQL Server 2012 SQL 2012 - General AlwaysOn: Client (Re)Connecting to wrong server after fail-over? RE: AlwaysOn: Client (Re)Connecting to wrong server after fail-over?

  • Replica SecondaryRoleConnections ReadonlyRoutingUrl

    [SQL-01] READ_ONLY tcp://SQL-01.MKT.LOCAL:1433

    [SQL-02] ALL {NULL}

    sys.availability_read_only_routing_lists contains (only) 1 record

    replica_id routing_priority read_only_replica_id

    SQL-01 1 SQL-01

    (replaced the GUID with the replica name)

    Does that help?

    Thanks, Frank