Service (Log On Tab)

SQL Server Configuration Manager

Microsoft SQL Server Configuration Manager is unable to identify this service.

SQL Server Configuration Manager receives service information from the WMI provider on the computer running the service. Either there was an error while reading the service properties, or the service properties are not complete. To resolve the problem, try closing and reopening SQL Server Configuration Manager, or check the WMI provider on the computer running the service.

The WMI provider is a Windows component. For information on how to check permissions on the WMI provider, see "How to: Configure WMI to Show Server Status in SQL Server Tools" in SQL Server Books Online.

If you believe you are viewing the correct service, use the Log On tab of the Unknown Service Properties dialog box to specify the account used by this service, and to start and stop the service.

Options

Local System account

Specify a local system account, which does not require a password. However, the local system account may prevent the service from interacting with other servers, depending on the privileges granted to the account.

This account

Specify a local or domain user account that uses Windows Authentication. We recommend using a domain user account with minimal rights for services. For information about selecting an account, "Setting Up Windows Service Accounts" in SQL Server Books Online.

Account Name

Specify the local or domain user account name.

Password

Type the password of the account.

Confirm password

Type the password of the account again.

Start

Start the service.

Stop

Stop the service.

Pause

Pause the service.

Resume

Resume a paused service.