Export (0) Print
Expand All
Expand Minimize

How to: Remove an Application from an Instance of Notification Services (Command Prompt)

SQL Server 2005

To remove a Notification Services application from an existing instance, you must modify the instance configuration and then update the instance. The following procedure shows what to modify and how to then perform the update using command-line utilities.

ms171400.note(en-US,SQL.90).gifNote:
The following procedure assumes you are configuring the instance of Notification Services by using an instance configuration file (ICF) and application definition files (ADFs). If you are using Notification Services Management Objects (NMO), use methods of the Microsoft.SqlServer.Management.Nmo.Instance class to update the instance of Notification Services.

  1. In the ICF, do the following:

    • Remove the Application node that represents the application.
    • Remove any application-specific custom protocols from the Protocols node.
    • Remove any application-specific delivery channels from the DeliveryChannels node.
    • Remove any application-specific default parameter values from the ParameterDefaults node.
  2. Back up the instance and application databases. For more information, see Backing Up and Recovering Notification Services.

  3. On the Start menu, point to All Programs\Microsoft SQL Server 2005\Configuration Tools, and then click Notification Services Command Prompt to open a command prompt window.

  4. Type the following command to disable the instance:

    nscontrol disable -name instanceName

  5. Type the following command to apply the changes made in the configuration file:

    nscontrol update -in configurationFile

    If the instance or application uses SQL Server authentication or you need to use command-line parameters, you will need to supply additional parameters. For more information, see nscontrol update Command.

  6. To update performance counters, reregister the instance of Notification Services using only the -name and -server arguments. If you do not use the performance counters, do not perform this step. Type the following commands to reregister the instance.

    1. net stop ns$ instanceName
    2. nscontrol register -name instanceName -server databaseServer
      When using SQL Server Authentication or argument encryption, you will need to supply additional parameters. For more information, see nscontrol register Command.
    3. net start ns$ instanceName
      ms171400.note(en-US,SQL.90).gifNote:
      If the instance of Notification Services is scaled-out across multiple servers, reregister the instance on each server.

  7. Type the following command to enable the instance:

    nscontrol enable -name instanceName

After you have updated the instance, you may want to delete the application objects from the application database, or, if the application has its own database, drop the entire database.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft