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)
 Uninstall SQL 2000 on a cluster then install 2005

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
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-09-16 : 13:17:09
Just uninstall from add/remove programs.

I would assume you can reuse the cluster group, IPs, etc...just have to uninstall 2000 first.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

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
Go to Top of Page

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.
Go to Top of Page
   

- Advertisement -