11/04/2008 21:52:36

The SQL Server 2005 Notification Services Components package provides the following server and client components that are required to deploy and run Notification Services:

This document contains the following sections:

1.0 About this Release

2.0 Deployment

3.0 Known Issues

4.0 More Information

1.0 About This Release

2.0 Deployment

The existing Notification Services deployment topologies continue to apply in this release of the Notification Services components. These topologies include single-server configurations, remote database server configuration, scale-out configurations, and high-availability configurations. For more information about Notification Services deployment topologies, see the topic, Hardware Configurations, in SQL Server 2005 Books Online.

2.1 Scenarios

This release of the SQL Server 2005 Notification Services components supports the following scenarios:

  • A new installation of this package in either of these configurations:
    • Both the Notification Services engine components and SQL Server 2005 are installed on the same server.
    • The Notification Services engine components are installed on a remote server and SQL Server 2005 is installed on the local server.
  • A new installation of this package in either of these configurations:
    • Both the Notification Services engine components and SQL Server 2008 are installed on the same server.
    • The Notification Services engine components are installed on a remote server and SQL Server 2008 is installed on the local server.
  • An existing installation of Notification Services in an environment that has been upgraded from SQL Server 2005 to SQL Server 2008.
    Note:
    After upgrade, SQL Server 2005 Notification Services will remain on the computer.

2.2 Requirements

To install the SQL Server 2005 Notification Services package, the computer must meet the same hardware and software requirements as the edition of SQL Server that hosts the databases. For more information about these requirements, see the topics, Hardware and Software Requirements for Installing SQL Server 2005 and Hardware and Software Requirements for Installing SQL Server 2008, in SQL Server Books Online.

If you perform a new installation of the SQL Server 2005 Notification Services components package, the following additional components are required for Notification Services functionality:

  • Microsoft SQL Server 2005 Management Objects (SMO) Collection
  • Microsoft SQL Server Native Client
  • SQL Server XML (This is required only if you want to use the XML event-loading features of Notification Services.)

These components must support the version of SQL Server that hosts the Notification Services engine instance. To obtain these components, download them from the latest release of the SQL Server 2005 Feature Pack, which is available on the Microsoft Download Center.

2.3 Editions

This release of the SQL Server 2005 Notification Services components supports storing Notification Services instance and application databases on the following editions of the SQL Server Database Engine:

SQL Server 2005 Standard Edition (32-bit)

SQL Server 2005 Standard Edition (64-bit) x64(AMD architecture / Intel Extended Systems architecture)

SQL Server 2005 Standard Edition (64-bit) IA64(Intel Itanium architecture)

SQL Server 2005 Developer Edition (32-bit)

SQL Server 2005 Developer Edition (64-bit) x64

SQL Server 2005 Developer Edition (64-bit) IA64

SQL Server 2005 Enterprise Edition (32-bit)

SQL Server 2005 Enterprise Edition (64-bit) x64

SQL Server 2005 Enterprise Edition (64-bit) IA64

SQL Server 2005 Evaluation Edition (64-bit) x64

SQL Server 2005 Evaluation Edition (64-bit) IA64

SQL Server 2008 Standard (32-bit)

SQL Server 2008 Developer Edition (32-bit)

SQL Server 2008 Enterprise Edition (32-bit)

SQL Server 2008 Standard (64-bit) x64

SQL Server 2008 Developer Edition (64-bit) x64

SQL Server 2008 Enterprise Edition (64-bit) x64

SQL Server 2008 Developer Edition (64-bit) IA64

SQL Server 2008 Enterprise Edition (64-bit) IA64

SQL Server 2008 Enterprise Edition Evaluation

For this release of the Notification Services components, the Developer, Enterprise, and Evaluation editions all have the same functionality. However, the Standard editions have some limitations. For more information, see the topic, Editions of Notification Services, in SQL Server Books Online.

2.4 Installation

To install the Notification Services components, you must first meet the requirements that are listed in this document. You can then download and run the Setup program for the Notification Services package. Setup will copy program files and configure the necessary components.

2.5 Upgrade

2.5.1 Upgrading the Notification Services Components Package Without Upgrading to SQL Server 2008

If you have an existing installation of the Notification Services components, you can upgrade to the current version. Before you upgrade the Notification Services components, stop the services for all Notification Services instances on the computer. Then download and run the Setup program for the Notification Services package. Setup will copy program files and configure the necessary components. Following the upgrade, verify that the Notification Services instances continue to work as expected. You do not need to run nscontrol upgrade on your instance or applications after installing the Notification Services components package.

2.5.2 Upgrading the Notification Services Components Package After Upgrading to SQL Server 2008

If you upgrade from SQL Server 2005 SP2 to SQL Server 2008, you can use the Notification Services component package to continue using SQL Server 2005 Notification Services. When you upgrade a computer from SQL Server 2005 SP2 with Notification Services to SQL Server 2008, Setup does not remove Notification Services from the computer. After upgrade finishes, SQL Server 2005 Notification Services remains on the computer and will be available in Add or Remove Programs. However, to continue to use SQL Server 2005 Notification Services after you upgrade to SQL Server 2008, you must perform one of these additional steps:

  • Install SQL Server 2005 SP3.
    —or—
  • Install this Notification Services components package and the required components that are listed in the Requirements section in this topic.
    —or—
  • Install Cumulative update package 9 from the Microsoft Help and Support Web site and then install this Notification Services components package..

2.6 Configuration

After you perform an upgrade or installation of this Notification Services components package, you might have to configure the edition of Notification Services that is specified in the registry. For more information, see section, 3.0 Known Issues, in this topic. For more information about how to configure and use Notification Services, see the how-to topics in the section, Managing Instances and Applications How-to Topics (Notification Services), in SQL Server 2005 Books Online.

2.7 Uninstall

If you no longer require Notification Services in your environment, you can uninstall the Notification Services components. To uninstall Notification Services, first follow the steps in the topic, Deleting Instances of Notification Services, in SQL Server 2005 Books Online. Then, use Add or Remove Programs to uninstall the Notification Services components package.

3.0 Known Issues

3.1 Notification Services Edition Might Be Incorrect in the Registry

The default edition of the Notification Services components package is Standard edition. This edition is used by default when this Notification Services components package is deployed without first installing SQL Server 2005. If you install the Notification Services components package on a computer that has an existing installation of SQL Server 2005, Notification Services might be configured for the incorrect edition of Notification Services, which prevents the Notification Services service from starting. If you are licensed for more than one edition of SQL Server, and the Notification Services components have to use one of those editions, you can configure the Notification Services edition information. To configure the Notification Services edition information, manually update the registry as described in the following procedure, and then use the nscontrol update command to ensure that the correct edition of Notification Services is used for your Notification Services instance and applications. For more information about the nscontrol utility and its syntax, see the topic, nscontrol Utility, in SQL Server 2005 Books Online.

Caution:
Incorrectly editing the registry can severely damage your system. Before making changes to the registry, you should back up any valued data on the computer.

To configure the Notification Services edition
  1. On Start menu, click Run.

  2. In the Run dialog box, type regedit, and then click OK.

  3. In the left pane, locate the following registry key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\NS\Setup.

    Note:
    If your installation is on a 64-bit version of Windows, the registry key is at HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\90\NS\Setup.

  4. Right-click in the right pane, point to New, and then click String Value.

  5. Click the new registry entry, and then name it RedistEdition.

  6. Right-click RedistEdition, and then click Modify.

  7. In the Edit String dialog box, type the value that corresponds to the SQL Server edition for which you are licensed:

    • Standard Edition
    • Developer Edition
    • Enterprise Evaluation Edition
    • Enterprise Edition
  8. Click OK.

  9. On the File menu, click Exit.

  10. Restart the Notification Services services.

4.0 More Information