Choosing the Right SQL Server Agent Service Account for Multiserver Environments

New: 14 April 2006

The Windows account you choose for the SQL Server Agent service can affect the behavior of a multiserver environment, as follows:

  • If you run the SQL Server Agent service under an account that is not a member of the local Windows Administrators group, enlisting target servers to master servers may fail. If it does, the following error message is returned:
    "The enlistment operation failed."
    Restart the SQL Server and the SQL Server Agent services to resolve this issue.
  • When the SQL Server Agent service is run under the Local System account, master server-target server operations are supported only if both the master server and the target server reside on the same computer. If you use this configuration, the following message is returned when you enlist target servers to a master server:
    "Ensure the agent start-up account for <target_server_computer_name> has rights to log on as targetServer."
    You can ignore this informational message. The enlistment operation should complete successfully.

For more information about choosing an account for the SQL Server Agent service, see Selecting an Account for the SQL Server Agent Service.

Community Additions