SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

Ginaz28
Starting Member

USA
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!

Peter99
Constraint Violating Yak Guru

485 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

tkizer
Almighty SQL Goddess

USA
36565 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
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

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

mcrowley
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  
 New 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.08 seconds. Powered By: Snitz Forums 2000