[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 445
  • Last Modified:

SQL Server 2008 Upgrade install non cluster issue

I am trying to upgrade from SQL Server 2000 to SQL 2008 standard and it tells me that the sql server is part of a cluster and can not continue. This server is a standalone server and has never had clustering installed.

This server is running windows server 2003 R2. This server was upgraded from windows 2000. I think it may have had the admin tools installed. I think the installer is picking up cluster administrator but i can not seem to remove it.

Any suggestions would help.

Thanks

Robert
0
BRAHelpdesk
Asked:
BRAHelpdesk
  • 2
  • 2
2 Solutions
 
Chris MConsulting - Technology ServicesCommented:
First of all, the SQL setup cannot show that the server is part of a cluster unless the OS is Enterprise edition and it's part of a cluster (a one node cluster).
It's possible to have a cluster with a single node in there.
You did not tell us which version of R2 you run - whether it's standard or enterprise.
Installing admin tools does not make an OS a cluster. You can have admin tools on any Windows OS (even Windows XP) but can only cluster Enterprise Edition.
Kindly find out by running cluster administrator: Start > run > type "cluadmin" (without quotes) and run that.
Choose to connect to your server as a cluster name so specify cluster name as your server name, IP address of your server name or simply a dot. If cluster administrator shows that indeed your server is part of a cluster then you will know.
Secondly, if your server is part of a cluster, then you will have to upgrade the database cluster to 2008 but if you dont want it as a cluster (in case it is anyway) then break the cluster using the SQL 2000 enterprise CDs and install SQL 2008 afresh.
Kindly note that you cannot uninstall the clustered SQL 2000 cluster from add/remove programs applet in the control pannel but can only do this by using the SQL 2000 CDs.
Thirdly, in case your SQL 2000 server is not running on top of a cluster, then you can do the following:
Detarch your production databases, uninstall your SQL 2000 server and install SQL 2008, after which you simpy attach your SQL 2000 databases. That will be a simple work around for you.
Remember to make backups of your SQL 2000 databases before you start this upgrade process.
Regards,
Chris Musasizi.
0
 
BRAHelpdeskAuthor Commented:
This server is windows 2003 server R2 Standard. This is not a cluster never has been.
 
 
0
 
Chris MConsulting - Technology ServicesCommented:
Hi, sorry for the late response.
If it's not clustered then you should be able to uninstall SQL server from the add/remove programs applet in control pannel.
Let's avoid the upgrade option and install SQL 2008 afresh by detaching the production databases from the SQL 2000 instance, uninstalling SQL 2000, installing SQL 2008 and attaching the databases in 2008.
Perform a full database backup just in case you would like to keep a copy of your databases compatible to SQL 2000.
Kindly note that you will not be able to use your databases in SQL 2000 anymore once they have been managed by an SQL 2008 instance.
All the best,
Chris.
0
 
BRAHelpdeskAuthor Commented:
Ironically the server ended up crashing a few days later. Lost 2 drives on RAID 5. I ended up rebuilding the server and used SQL Server 2008 from the start. Probably better any ways. Thanks for everyone's help.
 
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now