SQL Server Performance

cluster test using vm2005

Discussion in 'SQL Server Clustering' started by techbabu303, Dec 15, 2006.

  1. techbabu303 New Member

    Hi All,


    Been trying to set up test cluster for Sql server 2000 on virtual server 2005, found useful link and followed the steps listed below

    http://www.sql-server-performance.com/installing_sql_clustering_virtual_server1.asp

    Environment:
    ------------
    HOST OS windows XP SP2
    Virtual Server 2005
    Each node is running windows 2003 server SP1

    In creating two nodes with the same "public" virtual network which uses my host OS network card.

    when I start both nodes one of the nodes is having problems getting a IP address from DHCP server so remains unconnected, it is conflict.

    But when create another public virtual netwrok using same network card and assign this node 2 it works fine i.e both have different IP addresses but both the nodes are not able to ping each other. The host machine on which VM2005 is running is able to ping both the nodes.

    Any ideas would be great

    Cheers[?]
    Sat






  2. Argyle New Member

    Don't use two different public networks. Use the same network for both nodes and set a static IP for each node, don't use DHCP.
  3. techbabu303 New Member

    Thx ....i had tried using the same public network with dynamic ...will try with static now.

    cheers
    Sat
  4. techbabu303 New Member

    Tried using statis IP for both nodes , but one of the nodes is not able to connect to DHCP when trying to ipconfig /renew.

    They are not able to recoganize each other as before.

    Please suggest ???

    Cheers
    Sat
  5. techbabu303 New Member

    The static option I had enabled was "static Mac address" , in virtual server 2005 for each node using the same public virtual network.


    Cheers.
    Sat
  6. techbabu303 New Member

    Only with one Public virtual network shared by both nodes worked after removing the private virtual network...seems the private virtual network breaks it or something.

    Do I need to set up virtual network to achieve windows 2003 clustering and later sql server 2000 clustering ?

    Also does it make any difference if my test enviornment windows 2003 server are not activated yet ?

    Cheers
    Sat
  7. Argyle New Member

    Not static mac address. Static IP, meaning you specify an IP address manually and don't use DHCP. You should not run ipconfig /renew.

    Normally your private network is on IPs only used on that network for internal cluster communication (say 192.168.0.5 and 192.168.0.6). Then you have a public network that applications connect on.

    If you are setting up a test environment I guess you could use one single network that is for both internal cluster communications and for application communication.

    I'm not sure I understand your last question about active windows 2003.
  8. techbabu303 New Member

    Thx for the quick response.... you are right setting up IP addresses manually worked.

    Regarding the private network which would be used by the nodes for internal communication as you mentioned , do they need another network card which they share using the same virtual network or can the use existing one network card used by the nodes for public virtual network ?

    Yes it is a test environment which eventually will be used as model to build a real one, so want to understand the each stage.

    The last question is really related to OS installation and subsequent activation which is 60 day time period given by Microsoft..hope now Iam clear.

    Currently using the public network with two nodes , I was setting up the windows 2003 cluster on both nodes but when creating the cluster using the cluster wizard and it does the validation of both nodes I get the following error

    Which states for both nodes it gives the same message , any suggestions on this would be great !!

    -->Node2sat: checking the node feasibility gives error
    Error 0x8007170a This computer cannot be made a member of a cluster

    -->Node2sat: Validating operating system version on thsi node
    Error 0x8007170b This computer cannot me made the member of cluster because the
    correct version of windows installed.

    Environment:
    ------------

    Microsoft Virtual server 2005
    Both Nodes have Windows 2003 SP1 standard
    Public network shared on one LAN card
    Static IP's now assigned and part of the domain.




  9. techbabu303 New Member

  10. Argyle New Member

    You need one virtual network for the private network (often called heartbeat) and one virtual network for the public traffic. In practice this mean two network cards. Preferably you have even more cards so you can team two ports in failover mode.

    You need Windows 2003 Enterprise Edition to be able to cluster.

    The following SQL editions are needed for clustering:
    - SQL 2000 needs Enterprise Edition
    - SQL 2005 needs Standard Edition for two nodes and Enterprise Edition for 4 or more nodes.
  11. techbabu303 New Member

    Thx ....again !!

    Cheers
    Sat

Share This Page