March 26, 2015 at 10:05 am
Hi,
I have two servers (ServerA and ServerB) on cloud having SQL Server200R2 (64bit) installed on Windows Server 2008 connected with Workgroup. ServerA has default instance InstA and ServerB has named instance InstB. I have enabled TCP port on both the servers. When I connect InstB from ServerA, I have to mention server name as ServerA\InstaB,<port number>.
Now, I need to setup Mirroring between these two servers. ServerA will be the Principal server and ServerB will be the Mirror server. But when I setup mirroring between these instances and click on Start Mirroring it is throwing an exception "Network address TCP://ServerB:5022 is not reachable (Msg 1418)".
Can someone please help me to setup?
Thanks & Regards,
Anand
March 27, 2015 at 5:25 am
You have to open 5022 port on both the servers
March 27, 2015 at 5:53 am
anand.mind (3/26/2015)
Hi,I have two servers (ServerA and ServerB) on cloud having SQL Server200R2 (64bit) installed on Windows Server 2008 connected with Workgroup. ServerA has default instance InstA and ServerB has named instance InstB. I have enabled TCP port on both the servers. When I connect InstB from ServerA, I have to mention server name as ServerA\InstaB,<port number>.
Now, I need to setup Mirroring between these two servers. ServerA will be the Principal server and ServerB will be the Mirror server. But when I setup mirroring between these instances and click on Start Mirroring it is throwing an exception "Network address TCP://ServerB:5022 is not reachable (Msg 1418)".
Can someone please help me to setup?
Thanks & Regards,
Anand
This is a known issue, some have played with fake DNS aliases in the local hosts file to get round the name resolution issue.
sunder.bugatha (3/27/2015)
You have to open 5022 port on both the servers
Doesn't have to be 5022 can be any free port you choose
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply