Re: Standard to Enterprise

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
    ... You'll need to uninstall your Enterprise Edition and install a Standard Edition from scratch. ... instances of SQL Server services are both Standard Editions or Enterprise ... > different edition of Notification Services. ...
    (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)