Replication agent jobs may fail after you change the SQL Server Agent service startup account by using the Windows Service Control Manager in SQL Server 2005 (911305)


The information in this article applies to:

  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Workgroup
Bug #: 413203 (SQLBUDT)

SYMPTOMS

Consider the following scenario. On a computer that is running Microsoft SQL Server 2005, you use the Microsoft Windows Service Control Manager instead of SQL Server Configuration Manager to change the startup account of the SQL Server Agent service to a domain account. Then, you try to run a replication agent job. When you do this, the replication agent job may fail and you may receive an error message that is similar to the following:
Executed as user: <UserAccount>. Replication-Replication Snapshot Subsystem: agent <AgentName> failed. Executed as user: <UserAccount>. A required privilege is not held by the client. The step failed. [SQLSTATE 42000] (Error 14151). The step failed.

CAUSE

This problem occurs because the Windows Service Control Manager cannot grant the required permissions to run replication agent jobs to the new domain account.

RESOLUTION

To resolve this problem, use SQL Server Configuration Manager to change the domain account back to a startup account. Then, use SQL Server Configuration Manager to change the startup account to a domain account. When you do this, SQL Server Configuration Manager will add the domain account to the following security group:

SQLServer2005SQLAgentUser$ComputerName$InstanceName

Therefore, SQL Server Configuration Manager will grant the required permissions to run replication agent jobs to the domain account.

To avoid this problem in the future, we recommend that you use SQL Server Configuration Manager instead of the Windows Service Control Manager to modify startup accounts.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Modification Type:MinorLast Reviewed:1/20/2006
Keywords:kbsql2005repl kbExpertiseAdvanced kbbug KB911305 kbAudDeveloper kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.