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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Uninstall SQL 2000 on a cluster then install 2005
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

2 Posts

Posted - 09/16/2009 :  10:03:30  Show Profile  Reply with Quote
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!

Constraint Violating Yak Guru

498 Posts

Posted - 09/16/2009 :  13:15:38  Show Profile  Reply with Quote
First breadk cluster between two nodes, then uninstall sql 2000
Go to Top of Page

Almighty SQL Goddess

38200 Posts

Posted - 09/16/2009 :  13:17:09  Show Profile  Visit tkizer's Homepage  Reply with Quote
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

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

Starting Member

2 Posts

Posted - 09/17/2009 :  05:31:42  Show Profile  Reply with Quote
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.
Go to Top of Page

Aged Yak Warrior

771 Posts

Posted - 09/17/2009 :  15:46:21  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000