Virtual IP address for SQL cluster
Quick question about how virtual IP address works.
Let say I have SQL cluster with virtual IP address 192.168.100.10 and two nodes (192.168.100.1 and 192.168.100.2). Obviously when another host is connecting to SQL cluster uses virtual IP address and it works fine. But what happened when SQL cluster will connect to another host using SQL port. Which IP address it uses – virtual or own?
I checked it using telnet and it seems that unfortunately own. My problem is, I need to set up VPN connection between two SQL cluster and I would like to allow traffic only from one IP address. Is it possible to set up or not?
Kind Regards
Let say I have SQL cluster with virtual IP address 192.168.100.10 and two nodes (192.168.100.1 and 192.168.100.2). Obviously when another host is connecting to SQL cluster uses virtual IP address and it works fine. But what happened when SQL cluster will connect to another host using SQL port. Which IP address it uses – virtual or own?
I checked it using telnet and it seems that unfortunately own. My problem is, I need to set up VPN connection between two SQL cluster and I would like to allow traffic only from one IP address. Is it possible to set up or not?
Kind Regards