Clustering and existing instance of sql server 2000

[timscronin]

We have a client running a 3rd party app on sql 2000 Enterprise on Windows 2003 Advanced attached to a new SAN. They are looking at adding another SQL server and clustering for failover. Anyone done this before. Do you have to reninstall sql server on the original box to do this. This a a heavily used app, so downtime is always an issue.

 

[ptheriault]

Your going to have to re-install SQL Server.


- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[timscronin]

Ouch

 

[ptheriault]

If you are using Veritas your going to have to re-install that too.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[mrdenny]

Yep, SQL will need to be reinstalled and any client apps that connect will need to be updated to talk to the new name and IP address of the virtual world. Any firewalls will need to be updated to allow access to the new IP of the virtual world. If you are using DTC you will need to open a bunch of ports to all 4 IPs in the cluster.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com