Results 1 to 10 of 10
  1. #1
    Join Date
    Mar 2003
    Posts
    223

    How to get IP address of virtrue server in cluster?

    All:

    When I setup SQL Server cluster, the IP address of virtrue server is needed to fill in. How to get it before SQL Server installation?

    Thanks.

    ZYT
    ZYT

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    14,943
    Clusters are intended to be built using static IP addressing, where servers are assigned an IP address according to where and how those servers are wired into the enterprise. Each node should have an assigned IP address, as should the Windows and SQL virtual machines and those addresses should be delivered by the network architect (or whatever your organization calls the person that manages the IP infrastructure and assigns IP addresses).

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Mar 2003
    Posts
    223
    Pat:

    Thanks for the relay. Do you mean the virtrue server can get IP address like physical server? Each node is a physical server that should have IP address from the network.

    How to get IP address for a virtrue SQL server from network? I know it is beyond SQL Server DAB range. Just wish get it.

    ZYT
    ZYT

  4. #4
    Join Date
    Jun 2009
    Posts
    26
    Each physical server has an IP you assign it. When you create the cluster you create a clustered IP resource - this is the cluster IP and you assign it when you create the cluster. Basically the cluster IP is a secondary IP address that stays with the active node on the cluster.

    Hope that helps!

  5. #5
    Join Date
    Nov 2003
    Location
    denver
    Posts
    11

    How to find IP Address for any Instance of SQL Server

    There are several ways to get this information such as.
    1) Command prompt.
    2) SQl Server code.
    3) Cluster Manager.
    4) SQL Server Configuration tool.
    5) Registries.

    I typically use the SQL Server Configuration tool. follwing is the steps to find the IP address for a given SQL Server instance.

    To change the Port Number, do the following steps.

    1) Form start click on Microsoft SQl Server 2008\ Configuration Tools\ SQL Server Configuration Manager.

    2) Expand SQl Server network Cofiguration\ Protocols for SQL2008

    3) On your right hand Pane find "TCP/IP". you need to enable this protocol for using port number.

    4) Double click the "TCP\IP" and go to tab "IP Address".
    find "IP Address".

    Cheers
    Shailesh patangay

  6. #6
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    14,943
    yitongzhang was looking for a way to determine what value to use when installing the cluster, not how to find out what address was used after the cluster was already working.

    This is an issue of TCP/IP network design. I don't think there is any way to use DHCP to set the address of the virtual SQL Server. It needs to be a static address that is consistent with the local TCP/IP addressing standards (including sub-net routing, etc).

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  7. #7
    Join Date
    Mar 2003
    Posts
    223
    Hi, guys:

    Thanks a lot to all.

    To smiply question, I just want to know. How did you guys get virtrue IP address when you configure cluster SQL Server nodes? Or who give you the IP address, Win Admin or Network Admin? How did he/she get it?

    ZYT
    ZYT

  8. #8
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    14,943
    The network admin should give you static IP addresses for Windows virtual server, the SQL virtual server, and for each of the physical nodes in the cluster. They will decide what IP addresses make sense based on your datacenter's IP management scheme.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  9. #9
    Join Date
    Oct 2002
    Posts
    66
    I don't think anyone has answered the initial question here. What the poster is asking is what he can do to retrieve the IP address of the cluster, not assign it.

  10. #10
    Join Date
    Nov 2004
    Posts
    1,380
    Within four days that poor guy will have waited 2 full years for a decent answer.

    Shame on all of us on this forum!
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •