How to set the service startup account for SQL Server Agent (Enterprise Manager)

How to Install SQL Server 2000

How To

How to set the service startup account for SQL Server Agent (Enterprise Manager)

To set the service startup account for SQL Server Agent

  1. Expand a server group, and then expand a server.

  2. Expand Management, right-click SQL Server Agent, and then click Properties.

  3. Under Service startup account, do one of the following:
    • Click System account if your jobs require resources from the local server only.

    • Click This account if your jobs require resources across the network, including application resources; if you want to forward events to other Windows® application logs; or if you want to notify operators through e-mail or pagers.
  4. If you clicked This account, enter the Microsoft® Windows NT® 4.0 or Windows 2000 account name that SQL Server Agent will use, and then enter the password for this  account in the Password box.

You must restart SQL Server Agent before these configuration changes take effect.