Re: Problem upgrading named instance in SQL 2000

Hi,
Thanks a lot. That was the problem. I did not apply SP3 to the named
Instance.

Regards,
Sandhya


MeanOldDBA wrote:

Are you sure the named instance is also SP3? Double check. Remember, you
have to update each instance seperately.
--
MeanOldDBA
derrickleggett@xxxxxxxxxxx
http://weblogs.sqlteam.com/derrickl

When life gives you a lemon, fire the DBA.


"sandy" wrote:

Hi,

I have installed SQL 2000 Server on my machine with Default Instance
and a named instance viz., Instance1.I tried upgrading

the Database Engine of the Default instance to SQL 2005 Server (using
the 2005 Set up CD). It was upgraded successfully.
I tried upgrading the named instance's Database engien from SQL 2000 to
SQL 2005 server. After selecting the Database Engine

component and clicking Next, I got the following error:


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.

Service pack requirement check:
Your upgrade is blocked because of service pack requirements. To
proceed, apply the required service pack and then rerun SQL

Server Setup. For more information about upgrade support, see the
Version and Edition Upgrades topic in SQL Server 2005 Setup

Help or SQL Server 2005 Books Online.


Here are my machine details:
Processor: PIII Processor with
RAM: 512 MB
OS: Windows 2003 Server SP1
SQL2000: Enterprise edition with SP3
sql2005: Enterprise edition

Why is the upgrade not happening with respect to named instance whereas
it si happening with Default instance?

Thanks,
Sandhya



.

Relevant Pages

  • Re: SQL 2005 wont upgrade using R2 discs
    ... Are you sure the default instance you are trying to install isn't MSDE? ... Microsoft SQL Server 2005 Tools ... But I assume I need to upgrade the default instance too, but when I try that I get a similar error message. ... 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. ...
    (microsoft.public.windows.server.sbs)
  • Re: Connecting remotely through VPN
    ... Reason: Your upgrade is blocked. ... Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books ... information about edition upgrades, see the Version and Edition Upgrades ... I think that your SQL Browser Service did not work well. ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL 2005 wont upgrade using R2 discs
    ... But when I try and upgrade the default instance I still get this error: ... Microsoft SQL Server 2005 Tools ... I uninstalled the SQL 2000 version and it let me install ... information about edition upgrades, ...
    (microsoft.public.windows.server.sbs)
  • Re: Creating a new Access database file (.mdb) in .NET/C#
    ... You definitely need to download my Ebook. ... It can be passed around as a file like JET and backed up in a similar fashion. ... Consider that this database is also fully encryptable--a feature not in JET or in SQL Server until 2008. ... Per the MS product pages, I'm eligible for the Upgrade package, and ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQL 2005 wont upgrade using R2 discs
    ... Microsoft SQL Server 2005 Tools ... I uninstalled the SQL 2000 version and it let me install ... But I assume I need to upgrade the default instance too, ... information about edition upgrades, ...
    (microsoft.public.windows.server.sbs)