please help me fix Ms Sql Server mirroring multiple!

• quangnam81

  SSC Journeyman

  Points: 78

  More actions

  November 29, 2018 at 1:16 am

  #378717

  Hi all, plaeas hep me fix Sql mirroring.
  i create job mirroring SQL lab 3 server 
  192.168.1.3 - port 5023
  192.168.1.4 - port 5024
  192.168.1.5 - port 5025
  a finish all step but when i start job have error.
  
  i allow port 5024 in server firewall  and check telnet port 5024 ok 
  
  please help me fix it - Thanks all

• antenor.junior.81

  SSC Rookie

  Points: 32

  More actions

  December 20, 2018 at 9:09 am

  #2016967

  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.