Re: SQL 2005 won't upgrade using R2 discs

I've done that.

But when I try and upgrade the default instance I still get this error:

I have run it from Add/Remove and still get this error.
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





"Tristan" <tristan@xxxxxxxxxxxx> wrote in message
news:u4WOK6l%23GHA.3348@xxxxxxxxxxxxxxxxxxxxxxx
Ok will give it a go. Will you be around in the next half an hour in case
something goes horribly wrong?


"Susan Bradley, CPA aka Ebitz - SBS Rocks [MVP]" <sbradcpa@xxxxxxxxxxx>
wrote in message news:OEbD43l%23GHA.924@xxxxxxxxxxxxxxxxxxxxxxx
www.sbslinks.com/sql2005.htm
Follow that link. (I didn't post it just for grins ;-)
You need to remove the SQL 2000 and follow those instructions.

Tristan wrote:
I see there is still a copy of SQL 2000 in Add/Remove as well as the
newly installed SQL 2005.

Do I need to remove this version as well?

Will it break ISA 04 or Backup Exec?

Thanks for your help


"Tristan" <tristan@xxxxxxxxxxxx> wrote in message
news:u%23I%23Bpl%23GHA.4888@xxxxxxxxxxxxxxxxxxxxxxx
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









.