November 29, 2018 at 1:16 am
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
December 20, 2018 at 9:09 am
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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply