How to: Register an Instance of Notification Services for Engine Components (SQL Server Management Studio)

In the application definition, you specify which server runs each hosted event provider, generator, and distributor. On each of these servers, you need to run the Notification Services engine. Typically, the Notification Services engine is run by the NS$instanceName Microsoft Windows service, which you create when you register the instance of Notification Services. This topic describes how to register the instance of Notification Services and create this Windows service.

When you register an instance of Notification Services by using Microsoft SQL Server Management Studio, you are creating registry entries on the local server (not necessarily the database server). The database server value in the registry entry is the instance of the Database Engine to which you are connected in SQL Server Management Studio.

If you are hosting the Notification Services engine in a custom application, do not create the Windows service when you register the instance. For more information, see Hosting the Notification Services Engine.

  1. In SQL Server Management Studio, make sure you are connected to the instance of the Database Engine that hosts the instance and application databases.

  2. In Object Explorer, expand the Notification Services node.

  3. Right-click the instance you want to register, point to Tasks, and then select Register.

  4. Select the Create Windows service check box.

  5. Enter a logon account and password for the Windows service. This must be a local, domain, or built-in Windows account that is a member of the Users group on the local computer. For more information, see Configuring Windows Accounts for an Instance of Notification Services.

  6. If you use SQL Server Authentication to access databases, select SQL Server Authentication and enter a valid SQL Server login and password. Otherwise, leave Windows Authentication selected.

  7. If using argument encryption, select Encryption in the left pane and then enter the same encryption key used when creating the instance.

  8. Click OK to register the instance, create performance counters, and create the Windows service.

Community Additions