Re: SQL 2005 won't upgrade using R2 discs

Are you sure the default instance you are trying to install isn't MSDE?

I think you need to install an additional instance.

In the premium install steps it lists how to do that

Tristan wrote:
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







.