SQL 2000 won't install on SBS 2003

Posted on 2009-02-08
Last Modified: 2012-05-06
I am working on a SBS 2003 premium server.  SQL 2000 was installed by a previous tech.  We wanted to uninstall SQL and reinstall.  After uninstalling and rebooting, the setup for SQL will not run.  The splash screen will appear as well as the progress bar, but it doesn't move.  I can see the sqlsetup.exe in the task manager, but it does nothing.  After 5 - 10 minutes, it will just quit.  Splash screen and progress bar disappear.  Went thru the registry and got rid of all the MSSQL entries, but it did not help.
Question by:orthoschedule
    LVL 5

    Expert Comment

    SBS Premium comes with SQL does it not?

    why not go into control panel -> add remove -> windows components and find the SQL Server options.  Install that way?
    LVL 2

    Expert Comment

    are u installing from the original sbs 2003 media?  is it the same version of sql as the original install?

    Author Comment

    Yes and Yes
    LVL 2

    Accepted Solution

    thanks for that.

    ok, couple of questions.  are there any entries in the event viewer relating to the setup failure?  are you logging in with an admin account (sorry thought i should ask), are you going through the steps

    1. To Install SQL Server 2000

    Insert the Premium Technologies disc into the CD drive.
    Using Windows Explorer, browse to D:\SQL2000, where D is the letter of your CD drive.
    Double-click Autorun.exe.

    2. Stop some services, which can cause installation failure.

    you should stop these services before installing SQL Server 2000, and then restart them once SQL Server has been successfully installed. Stop the following services:

    IIS - Internet Information Server
    Exchange Server
    SNA Server
    Disk Keeper
    SNMP Service
    Anti-virus software (such as McAfee)
    Backup products (such as ARC Server)

    3. check for the following registry entries and remove if they are there.  taking a backup of the registry would be recommended before you do anything to the registry


    4. remove the previous installation directory

    5. check setup logs

    hopefully these will help, you might have already done some of the steps but let us know how you get on.

    Expert Comment

    I would like to ask an additional question for clarification.
    I have SBS Standard and am trying to get a BlackBerry to work with the Exchange mail.
    I am told that I need to install a named instance of SQL 2000 or SQL 2005.
    Does SQL 2000 only come with SBS Premium and not with SBS Standard?  I have been unable to find SQL 2000 on my SBS Standard disks. Will I need to purchase a copy of SQL 2000 or 2005?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

    758 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

    13 Experts available now in Live!

    Get 1:1 Help Now