Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Installing SQL 2000 in an Active/Passive Cluster

Author  Topic 

jpotucek
Constraint Violating Yak Guru

273 Posts

Posted - 2004-12-03 : 07:53:42
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????

MichaelP
Jedi Yak

2489 Posts

Posted - 2004-12-03 : 14:28:41
You'll need two more, one for SQL Server and one for MSDTC.
I recently setup SQL 2000 in Active / Passive mode on a Win2003 cluster, so if you have any further questions, feel free to ask! There's MS KB article that goes into how to do the installation, but I could not find it. You should be able to google it though.

Read these articles!
http://support.microsoft.com/default.aspx?scid=kb;en-us;301520

http://support.microsoft.com/kb/301600

Michael

<Yoda>Use the Search page you must. Find the answer you will.</Yoda>
Go to Top of Page
   

- Advertisement -