Re: Standard to Enterprise

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Is there any way to downgrade the Enterprise server to Standard?

You'll need to uninstall your Enterprise Edition and install a Standard Edition from scratch.

--
Ekrem Önsoy - SQL Server MVP



"Tom" <Tom@xxxxxxxxxxxxxxxxxxxxxxxxx>, iletisinde şunu yazdı, news:517A33BC-0901-400C-BB3E-6AF0C600C39C@xxxxxxxxxxxxxxxx
This could be, but I can’t understand why the notification service could have
been started in the first place if there were two different versions of SQL
server.

Is there any way to downgrade the Enterprise server to Standard?

Thanks for your help.
Tom


"Ekrem Önsoy" wrote:

Is this an active\active two node cluster? If so, Are you sure that
instances of SQL Server services are both Standard Editions or Enterprise
Editions?

My guess is that you have two active SQL Server instances (and notification
services) and one of them is Standard Edition and the other one is
Enterprise Edition.

--
Ekrem Önsoy


"Tom" <Tom@xxxxxxxxxxxxxxxxxxxxxxxxx>, iletisinde şunu yazdı,
news:BDAEF969-F8CE-4065-AAD3-2EA8E11D0640@xxxxxxxxxxxxxxxx
>I am asking because we had a notification service running for 3 months, >the
> other day we had to fail over out cluster so the service stopped and > tried
> to
> start on the other node, But it wouldn’t start. We received the > following
> event log. The only changes to the server have been patches and > service
> packs. And as I said the service was running fine for months.
>
> Event Type: Error
> Event Source: NotificationServices
> Event Category: None
> Event ID: 99
> Date: 3/30/2009
> Time: 10:10:29 AM
> User: N/A
> Computer: MOTHER
> Description:
> The Notification Services instance encountered an error in one of its
> components and must stop.
> EventParameters:
> Instance Name: BAMAlerts
> Problem Description: The database was created with or upgraded to a
> different edition of Notification Services. Use the Notification > Services
> edition that the database expects.
> Notification Services Edition: Enterprise Edition (64-bit)
> Database Edition: Standard Edition (64-bit)
> ----
>
> "Ekrem Önsoy" wrote:
>
>> You must run SQL Server 2005 Enterprise Edition to upgrade your SQL
>> Server
>> 2005 Standart Edition to Enterprise Edition. There is no such a patch >> or
>> service pack for upgrade.
>>
>> -- >> Ekrem Önsoy
>>
>>
>> "Tom" <Tom@xxxxxxxxxxxxxxxxxxxxxxxxx>, iletisinde şunu yazdı,
>> news:06087524-C1D4-4D48-96C9-0D7F8B3E81A8@xxxxxxxxxxxxxxxx
>> > Is it possible for a SQL 2005 service pack (or any other patch) to
>> > change
>> > the
>> > SQL version from Standard to Enterprise?
>> >
>> > Thanks
>> >
>>


.

Relevant Pages

  • Re: Standard to Enterprise
    ... My guess is that you have two active SQL Server instances (and notification services) and one of them is Standard Edition and the other one is Enterprise Edition. ...
    (microsoft.public.sqlserver.setup)
  • Re: Standard to Enterprise
    ... You'll need to uninstall your Enterprise Edition and install a Standard ... instances of SQL Server services are both Standard Editions or Enterprise ... The Notification Services instance encountered an error in one of its ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server 20005 Licensing
    ... So it's basically Enterprise Edition. ... Upgrading and Uninstalling the Trial Software ... upgraded to the fully licensed version of SQL Server 2005 Enterprise Edition ... Standard Edition, Workgroup Edition, or Developer Edition, it is recommended ...
    (microsoft.public.sqlserver.setup)
  • Re: Standard to Enterprise
    ... been started in the first place if there were two different versions of SQL ... services) and one of them is Standard Edition and the other one is ... The Notification Services instance encountered an error in one of its ... Notification Services Edition: Enterprise Edition ...
    (microsoft.public.sqlserver.setup)
  • RE: SQL Standard versus Enterprise
    ... I think in SQL Server 2008 Standard Edition and Enterprise Edition; ... you have full Database Mirroring which can provide for HA solution. ...
    (microsoft.public.sqlserver.clients)