installing sql server 2000 in a cluster (2003 server)

• potucekj

  Default port

  Points: 1414

  More actions

  December 3, 2004 at 6:00 am

  #87111

  How many static IPs do I need for an Active/Passive SQL Server Cluster on WIN2003?    I'm thinking 4: one for each of the nodes in the Cluster, one for the Cluster Resource itself and one for the Default/Virtual SQL Server Instance.  Is there a good HOW-TO article on how to do this?  Clustering is already setup on the Servers and I have 3 IP addresses so far (each node and the Cluster) but during setup, I believe that I have to name the Instance and give it another IP address????

• Gé Brander

  SSCarpal Tunnel

  Points: 4353

  More actions

  December 6, 2004 at 1:55 am

  #532600

  2 - Node 1 (one for the network and one for the heartbeat)

  2 - Node 2 (one for the network and one for the heartbeat)

  1 - Cluster group (for the clusterip)

  1 - MSDTC group (for the msdtcip - Always use a seperate MSDTC group!)

  1 - Per SQL Server instance (= virtual server - You can install multiple instances on a cluster and keep active/passive)

  __ +

  7 - So you need a minimum of 7 IP addresses.