SQL Server Properties (Log On Tab)

SQL Server Configuration Manager

previous page next page

Use the Log On tab of the SQL Server Properties dialog box to specify the account used by the SQL Server service, to change the password of an account, and to start and stop the service. Changing the password of an account takes effect immediately.

Note:
When changing the account name used by a service on a clustered instance, the new account must be a member of the domain group specified during setup for the service being changed, or you must have permission to add members to that group. If you do not have permission to modify group membership, contact the domain administrator. For more information about selecting an account to run the service, see "Setting Up Windows Service Accounts" in SQL Server Books Online.

Note:

When changing the account name used by a service on a clustered instance, the new account must be a member of the domain group specified during setup for the service being changed, or you must have permission to add members to that group. If you do not have permission to modify group membership, contact the domain administrator.

For more information about selecting an account to run the service, see "Setting Up Windows Service Accounts" in SQL Server Books Online.

Options

Built-in account

Local System

Specify the local system account. This account 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.

Local Service

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

Network Service

We recommend that you do not use the Network Service account for the SQL Server or the SQL Server Agent services. Local User or Domain User accounts are more appropriate for these services.

This account: Specify a local or domain user account that uses Windows Authentication. We recommend that you use a domain user account that has minimal rights for services.

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.

Note:
When starting SQL Server, a WMI error containing the phrase "not implemented [0x80004001]" may indicate that SQL Server is not installed on the target computer.

previous page start next page