Sunday, February 12, 2012

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

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>--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.|||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.|||Bill,
I dont know why the upgrade option is grayed out in this case.Did you check
the log files for any hints/error messages?
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Bill Gianoukos" <anonymous@.discussions.microsoft.com> wrote in message
news:c20f01c4384c$ef1ece60$a601280a@.phx.gbl...
> 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
>

No comments:

Post a Comment