If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Microsoft SQL Server > How to get IP address of virtrue server in cluster?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
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
Reply With Quote
  #2 (permalink)  
Old
Resident Curmudgeon
 
Join Date: Feb 2004
Location: In front of the computer
Posts: 14,424
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.
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
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
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
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!
__________________
Wilvis
Databases Made Easy
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
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
Reply With Quote
  #6 (permalink)  
Old
Resident Curmudgeon
 
Join Date: Feb 2004
Location: In front of the computer
Posts: 14,424
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.
Reply With Quote
  #7 (permalink)  
Old
Registered User
 
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
Reply With Quote
  #8 (permalink)  
Old
Resident Curmudgeon
 
Join Date: Feb 2004
Location: In front of the computer
Posts: 14,424
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.
Reply With Quote
  #9 (permalink)  
Old
Registered User
 
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.
Reply With Quote
  #10 (permalink)  
Old
Registered User
 
Join Date: Nov 2004
Posts: 1,359
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/2008 R2 Earned beers: 16
Wim
Beware of bugs in the above code; I have only proved it correct, not tried it. -- Donald Knuth
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
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On