Cluster server connection

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Oren Zippori - 25 Sep 2005 10:17 GMT

Good day,
I have recently installed a 2 node cluster server with SQL 2000 SP3 in my
network. and have found out that users connect to the Virtual cluster server
inorder to receive SQL services but they get the replay for the physical
node that holds the SQL.
I was wondering if this configuration can be changed so that the SQL servers
answers back with the IP address of the virtual server and not the physical
cluster.
the problem is that im working with a Firewall and we would like to restrict
the number of IP address that we expose to the world.

Thanks in advance
Oren Zippori

Reply to this Message

Geoff N. Hiten - 25 Sep 2005 19:36 GMT

This is one of the wierd but unavoidable artifacts of clustering. You will
have to expose the host computer's IP addresses through the firewall.
Personally, I like to run my database servers on an restricted segment, just
to minimize the impact of stuff like this.

Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

> Good day,
> I have recently installed a 2 node cluster server with SQL 2000 SP3 in my
[quoted text clipped - 9 lines]
> Thanks in advance
> Oren Zippori

Reply to this Message

Oren Zippori - 26 Sep 2005 06:47 GMT

Thanks for the information on this Geoff.

> This is one of the wierd but unavoidable artifacts of clustering. You
> will have to expose the host computer's IP addresses through the firewall.
[quoted text clipped - 18 lines]
>> Thanks in advance
>> Oren Zippori

Reply to this Message