Re: SQL 2005 won't upgrade using R2 discs

Hi,

I uninstalled the SQL 2000 (Sharepoint) version and it let me install SQL
2005 and successfully created the SHAREPOINT instance.

The whole point of moving to upgrading to SQL 2005 is on request from the
accounting firm which will be install the latest version of Great Plains.

But I assume I need to upgrade the default instance too, but when I try that
I get a similar error message.

Name: Microsoft SQL Server 2000

Reason: Your upgrade is blocked. For more information about upgrade support,
see the "Version and Edition Upgrades" and "Hardware and Software
Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books
Online.

Edition check:

Your upgrade is blocked because of edition upgrade rules. For more
information about edition upgrades, see the Version and Edition Upgrades
topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

Name: Microsoft SQL Server 2005 Tools

Allowed Action: Maintain (Action is only available from Add or Remove
Programs)

Reason: Cannot maintain product, to maintain the product go to Add or Remove
Programs






"Susan Bradley, CPA aka Ebitz - SBS Rocks [MVP]" <sbradcpa@xxxxxxxxxxx>
wrote in message news:Ocqa9Xl%23GHA.1220@xxxxxxxxxxxxxxxxxxxxxxx
You don't upgrade.. you uninstall the old SQL and install the new one
Read the readme file

www.sbslinks.com/sql2005.htm

Been there, done that.

Tristan wrote:
Hi,

I upgraded our SBS 03 SP1 box fine to SBS 03 R2 with SQL 2005. I'm now
at a clients trying to do the same, should be similar configuration.
I'm now at the point of upgrading to SQL 2005 and are following the
install docs that come with the R2 discs.

If I look at the installed instances it shows the following:

SQL Server 2000
Version 8.00.761
Standard Edition

SQL Server Desktop Edition (BKUPEXEC)
Version 8.00.761
Desktop Engine

SQL Server Desktop Engine (MSFW)
Version 8.00.761
Desktop Engine

SQL Server Desktop Engine (SBSMonitoring)
Version 8.00.1100
Desktop Engine

SQL Server (Sharepoint)
Type: Microsoft SQL Server 2000
Version 8.00.761
Standard Edition

SQL Server (WSUS)
Type: Microsoft SQL Server Desktop Engine (WSUS)
Version 8.00.1100
Desktop Engine

It says "The following components that you chose to install are already
installed on the machine." If I click the details button it says:

Name: Microsoft SQL Server 2000
Reason: Your upgrade is blocked. For more information about upgrade
support, see the "Version and Edition Upgrades" and "Hardware and
Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server
2005 Books Online.

Edition check:

Your upgrade is blocked because of edition upgrade rules. For more
information about edition upgrades, see the Version and Edition Upgrades
topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

Help!

Thanks

Tristan






.