Skip to content

Latest commit

 

History

History
50 lines (38 loc) · 2.08 KB

File metadata and controls

50 lines (38 loc) · 2.08 KB
title SQL Server Agent Properties (Log On Tab)
ms.custom seo-lt-2019
ms.date 03/14/2017
ms.prod sql
ms.prod_service sql-tools
ms.reviewer
ms.technology configuration
ms.topic conceptual
ms.assetid 01fc6329-5d6b-4186-9565-395f375477bb
author markingmyname
ms.author maghan
monikerRange >=sql-server-2016||=sqlallproducts-allversions

SQL Server Agent Properties (Log On Tab)

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md-winonly] Use the Log On tab of the SQL Server Agent Properties dialog box to specify the account used by the [!INCLUDEssNoVersion] Agent service, and to start and stop the service. Changing the password of an account takes effect immediately without restarting the service.

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.

Options

Local System account
Specify a local system account, which does not require a password. However, the local system account may restrict 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. [!INCLUDEmsCoName] recommends using a domain user account with minimal rights for services. For information about selecting an account, search Books Online for "Setting Up Windows Service Accounts."

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.