Re: Can't upgrade sql server 2000 from professional to standard edition.

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Dinesh T.K (tkdinesh_at_nospam.mail.tkdinesh.com)
Date: 05/12/04 

Date: Thu, 13 May 2004 03:04:02 +0530

Hi,

Not sure what you meant by " You can not easily upgrade".It *is* possible to
upgrade pers edition to std edition. 

--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
<anonymous@discussions.microsoft.com> wrote in message
news:c4d601c43864$cb6cd990$a301280a@phx.gbl...
>
> >-----Original Message-----
> >Hello Members,
> >
> >
> >I by accident installed SQL server 2000 personal edition
> >on a Windows 2000 server.  I want to upgrade it to
> >standard edition to allow for more threads and users.
> >When i put in the standard cd and get to the upgrade
> >screen, the option for upgrade is grade out and I can't
> >click it.
> >
> >Does anybody know why this happens and what I can do to
> >upgrade to the standard edition.
> >
> >Regards,
> >Bill Gianoukos.
> >
> >PS.. please also feel free to email me responses to
> >billg@otpas.com
> >
> >.
> >
> You can not easily upgrade, install new instance and
> migrate database over.

Relevant Pages

  • Re: Upgrade Path - Do I need to downgrade first?
    ... can I do an in-place upgrade directly to 2k5 SE without first ... I downgraded/upgraded from SQL Server 2000 Enterprise Edition to SQL Server ... those will no longer work in Standard Edition. ...
    (microsoft.public.sqlserver.setup)
  • Re: Upgrade from Personal to Standard?
    ... You can directly do a edition upgrade by inserting the Standard edition CD. ... > We have a system recently installed here which is running on SQL Server ... > Personal Edition. ...
    (microsoft.public.sqlserver.setup)
  • 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)