Instance Properties (Windows Services)

  • Article

Use to start and stop NS$instance_name Microsoft Windows services and to view which components run on the selected server. If an instance is scaled-out across multiple servers, you can start and stop the Windows service on individual servers.

Options

  • Services
    Lists the servers that run the NS$instance_name Windows service for the instance of SQL Server 2005 Notification Services. If the instance runs on one server, only that server is listed. If the instance is scaled-out across multiple servers, each server that runs the NS$instance_name Windows service is listed.

    The following table describes the columns in the Windows services grid.

    Column Description

    Start

    Select to start the Windows service or clear to stop the Windows service. The service will start or stop when you click OK.

    Server

    The name of the server

    Current Status

    The current status of the Windows service. The status can be one of the following values:

    • The service is not installed.
    • Stopped.
    • Starting.
    • Started.
    • Stopping.
    • Access denied.
    • General network error.

    If the status is "The service is not installed," the application definition specifies that a hosted event provider, generator, or distributor has a SystemName value equal to the value in the Server field, but the Windows service is not installed on that computer. Make sure that you have registered the instance on the computer specified in the Server field, creating the Windows service during registration.

    If the Windows service does not start, it is typically a problem with the account that is used to run the service. The account name and password might be mistyped. Or the account might not have the necessary SQL Server and Windows permissions. If the Windows services run on remote computers, make sure SQL Server is configured to accept remote connections. Also make sure that the instance was registered with the correct instance of SQL Server, and that the instance of SQL Server and databases are online and available.

  • Associated components
    When you select a row in the Windows services grid, the Associated components grid shows the instance components that run on that server.

    The following table describes the columns in the Associated components grid.

    Column Description

    Type

    The component category. Possible values are:

    Event Provider

    Generator

    Distributor

    Name

    The name of the component. Names for event providers are from the application definition. Notification Services creates the names for generators and distributors.

    Current Status

    The current status of the component. The status can be Enabled, Enable Pending, Disabled, Disable Pending. For descriptions of these values, see Viewing the Status of Instances, Applications, and Components.

See Also

Reference

Notification Services F1 Help

Other Resources

Securing Notification Services
Viewing the Status of Instances, Applications, and Components
Enabling and Disabling Instances, Applications, or Components
nscontrol enable Command
nscontrol disable Command

Help and Information

Getting SQL Server 2005 Assistance