• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 398
  • Last Modified:

SQL 2000 won't install on SBS 2003

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.
0
orthoschedule
Asked:
orthoschedule
1 Solution
 
Jaymz_RCommented:
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?
0
 
themantheycallbrianCommented:
are u installing from the original sbs 2003 media?  is it the same version of sql as the original install?
0
 
orthoscheduleAuthor Commented:
Yes and Yes
0
 
themantheycallbrianCommented:
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

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServer HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLServerAgent HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server

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.
0
 
jet0654Commented:
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?
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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