Microsoft KB Archive/907557

= The supported Windows account types that you can use to run the SQL Server Agent service in SQL Server 2005 =

Article ID: 907557

Article Last Modified on 11/20/2007

-

APPLIES TO


 * Microsoft SQL Server 2005 Enterprise Edition
 * Microsoft SQL Server 2005 Enterprise X64 Edition
 * Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems
 * Microsoft SQL Server 2005 Standard Edition
 * Microsoft SQL Server 2005 Standard X64 Edition
 * Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems
 * Microsoft SQL Server 2005 Developer Edition

-



INTRODUCTION
SQL Server Agent is a Microsoft SQL Server 2005 component that lets you automate some administrative tasks. SQL Server Agent runs jobs, monitors SQL Server, and processes alerts.

The Microsoft Windows account types that are supported and that you can use to run the SQL Server Agent service are listed in the table in the &quot;More information&quot; section. Use SQL Server Configuration Manager to set the service account for SQL Server Agent.

For more information, see the &quot;How to set the service startup account for SQL Server Agent (SQL Server Configuration Manager)&quot; topic in SQL Server 2005 Books Online (December 2005 update).

To obtain SQL Server 2005 Books Online (December 2005 update), visit the following Microsoft Web site:

http://technet.microsoft.com/en-us/sqlserver/bb428874.aspx



Supported service account types
The following table lists the Windows account types that are supported and that you can use to run the SQL Server Agent service.

Limitation 1: When you use a nonadministrative account for multiple-server administration
When you use a nonadministrative account for multiple-server administration, you cannot enlist target servers to a master server, and the following error message may be logged:

&quot;The enlist operation failed.&quot;

To resolve this problem, restart both the SQL Server service and the SQL Server Agent service.

For more information, see the following topics in SQL Server 2005 Books Online (December 2005 update):
 * &quot;How to restart an instance of SQL Server (SQL Server Management Studio)&quot;
 * &quot;How to restart the SQL Server Agent service (SQL Server Management Studio)&quot;

Limitation 2: When you use the Local System account for multiple-server administration
Multiple-server administration is supported when the SQL Server Agent service runs under the Local System account only when both the master server and the target server reside on the same computer. If you use this configuration, you receive the following message when you enlist target servers to the master server:

Ensure the agent start-up account for  has rights to log on as targetServer.

You can safely ignore this informational message. The enlistment operation should successfully finish.

For more information, see the &quot;Creating a multiserver environment&quot; topic in SQL Server 2005 Books Online (December 2005 update).

Limitation 3: When you use a local user account
Jobs that use proxies will fail if the SQL Server Agent service runs under a local user account and the SQL Server service runs under a different account.

To resolve this problem, configure the SQL Server Agent service and the SQL Server service to run under the same local account, and then restart both services.

For more information, see the following topics in SQL Server 2005 Books Online (December 2005 update):
 * &quot;How to change the service startup account for SQL Server (SQL Server Configuration Manager)&quot;
 * &quot;How to set the service startup account for SQL Server Agent (SQL Server Configuration Manager)&quot;
 * &quot;Setting up Windows service accounts&quot;

Note Limitation 3 does not apply to Microsoft SQL Server 2005 Service Pack 1 (SP1). For more information about how to obtain SQL Server 2005 Service Pack 1, click the following article number to view the article in the Microsoft Knowledge Base:

913089 How to obtain the latest service pack for SQL Server 2005

Limitation 4: When you use the Network Service account and the Network Service account is a SQL Server user
SQL Server Agent may not start if the following conditions are true:
 * You configure the SQL Server Agent service to run under the Network Service account.
 * The Network Service account was explicitly granted access to log in to an instance of SQL Server as a SQL Server user.

To resolve this problem, restart the computer that is running SQL Server. You only have to restart the computer one time.

Limitation 5: When you use the Network Service account and SQL Server Reporting Services is running on the same computer
SQL Server Agent may not start if the following conditions are true:
 * You configure the SQL Server Agent service to run under the Network Service account.
 * SQL Server Reporting Services is also running on the same computer.

To resolve this problem, restart the computer that is running SQL Server, and then restart both the SQL Server service and the SQL Server Agent service. You only have to do this one time.

