Home Forums Career Job Postings please help me fix Ms Sql Server mirroring multiple! RE: please help me fix Ms Sql Server mirroring multiple!

  • I don´t know if your resolved yout problem.

    I see that you use a non-default port on SQL instance, if all intances are configured this way, i think it´s necessary to configure the PORT of SQL service too on the mirroring on the SQL INSTANCE NAME, like MIRROR: MsSQL1,14333:5024

    example: [NAME or IP SERVER],[SQL PORT]:[MIRROR PORT]

    If your SQL INSTANCE are configurated on different default port the communication it´s not work if you don´t pass that different port on sql connection.

    another solve to the computer understand the full link communication with another port are add a line on archive DRIVERS.TXT on folder windows\system32\drivers

    example:
    127.0.0.1,[PORT] [NAME SERVER]
    MsSQL1, 23333 MsSQL_MIRROR

    And just use this NAME SERVER on communication, like:
    TCP://MsSQL_MIRROR:5024

    I hope to help you.