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.
| Author |
Topic |
|
Ginaz28
Starting Member
2 Posts |
 Posted - 2009-09-16 : 10:03:30
|
| Hi, we need to uninstall sql 2000 on a cluster on a Windows 2003 server, then do a fresh installation of sql 2005 using the same cluster. Is the best way to uninstall sql 2000 by using the setup program on the CD? Do we need to do anything with the 2-node active/passive cluster prior to uninstalling? When we install sql 2005, can we use the same sql group for the cluster, as well as the same IPs? Will the uninstall of 2000 do anything to the service account or permissions? Thanks in advance for responses! |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2009-09-16 : 13:15:38
|
| First breadk cluster between two nodes, then uninstall sql 2000 |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Ginaz28
Starting Member
2 Posts |
Posted - 2009-09-17 : 05:31:42
|
| Can you please explain "break the cluster"? Also, if the cluster group has already been created in SQL 2000, will it be deleted when I uninstall? If not, do I delete it prior to installing SQL 2005. I am concerned about getting an error that there is an existing cluster with that same name when I try to install 2005.Thanks |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2009-09-17 : 15:46:21
|
| We did not have to break the cluster in any way to do the uninstall. The SQL 2000 setup program needs to realize that there are two (or 1 per node) installs of SQL server on the cluster. Remember, the SQL Server setup will work on the Virtaul Server name, and not just on whatever binaries it finds on the disk. |
|
|
|
|
|
|
|
|
Uninstall SQL 2000 on a cluster then install 2005