cluster virtual IP and outgoing traffic.

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

Incomming connections from clients to the SQL instance should be configured
to the IP address configured in the group, as you call the "virtual" IP.

However, expect all outgoing traffic to come from the IP addres of the Node
where the group is online. This is normal and by design

HTH,
Edwin.


"Piotr" <> wrote in message
news:5D93B1D8-F5EC-4560-9613-...
> 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

Many thanks for your reply.
Could you also tell me If there is any way to configure cluster that
outgoing traffic will use virtual IP dedicated for cluster not host?


"Edwin vMierlo [MVP]" wrote:

> Incomming connections from clients to the SQL instance should be configured
> to the IP address configured in the group, as you call the "virtual" IP.
>
> However, expect all outgoing traffic to come from the IP addres of the Node
> where the group is online. This is normal and by design
>
> HTH,
> Edwin.
>
>
> "Piotr" <> wrote in message
> news:5D93B1D8-F5EC-4560-9613-...
> > 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
>
>
>

Not that I am aware off
rgds,
Edwin.


"Piotr" <> wrote in message
news:F92884DD-EB3A-465D-ADD2-...
> Many thanks for your reply.
> Could you also tell me If there is any way to configure cluster that
> outgoing traffic will use virtual IP dedicated for cluster not host?
>
>
> "Edwin vMierlo [MVP]" wrote:
>
> > Incomming connections from clients to the SQL instance should be
configured
> > to the IP address configured in the group, as you call the "virtual" IP.
> >
> > However, expect all outgoing traffic to come from the IP addres of the
Node
> > where the group is online. This is normal and by design
> >
> > HTH,
> > Edwin.
> >
> >
> > "Piotr" <> wrote in message
> > news:5D93B1D8-F5EC-4560-9613-...
> > > 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
> >
> >
> >

Thanks Edwin