SQL Server 2008 Upgrade install non cluster issue

Posted on 2009-04-20
Last Modified: 2012-06-27
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.


Question by:BRAHelpdesk
    LVL 12

    Accepted Solution

    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.
    Chris Musasizi.
    LVL 1

    Author Comment

    This server is windows 2003 server R2 Standard. This is not a cluster never has been.
    LVL 12

    Assisted Solution

    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,
    LVL 1

    Author Comment

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    On July 14th 2015, Windows Server 2003 will become End of Support, leaving hundreds of thousands of servers around the world that still run this 12 year old operating system vulnerable and potentially out of compliance in many organisations around t…
    How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now