September 29, 2005 at 3:18 pm
Hello,
I have to install an active/passive SQLServer 2000 on windows server 2003. During this install, i must give a name and a virtual IP adress for the cluster. Is it the same IP than the virtual IP of the windows server 2003 ? Do i need a specific IP adress ? The default ?
Thanks for your help
September 29, 2005 at 3:22 pm
tough question since we cannot see where you are in the installation process.
Ips are assigned to
Each node in the cluster.
And the virtual server. Which is where sql server lives.
Attached link from booksonline for all the considerations
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_clustering_2icn.asp
September 30, 2005 at 2:20 am
Hard to tell without seeing where you are in the setup, but the basic idea is that you have the real names and IP address of the machines say Machine1 & Machine2. Then you create a virtual name for the cluster ie MachineCluster1 so whenever you are connecting to the cluster you point at that address and in the event of a failover the virtual MachineNames & IP points at Machine2 rather than Machine1
Fairly simplistic view of it but hope it makes sense
October 1, 2005 at 1:18 am
You'll need a number of IP addresses:
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
October 4, 2005 at 4:55 am
You can take a look at this doc.
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx
October 11, 2005 at 12:35 pm
After the "licence agreement window", i have to give an IP adress in the "failover clustering window". Is this IP the same than the virtual IP adress of the cluster windows server 2003 ?
October 11, 2005 at 12:57 pm
I'm guessing the "Virtual SQL Server Instance IP" ...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply