MSSQL_ENG021798
Message Details
Product Name |
SQL Server |
Product Version |
9.0 |
Product Build Number |
9.00.1399.60 |
Event ID |
21798 |
Event Source |
MSSQLSERVER |
Component |
SQL Server Database Engine |
Symbolic Name |
|
Message Text |
The '%s' agent job must be added through '%s' before continuing. Please see the documentation for '%s'. |
Explanation
To create a publication, you must be a member of the sysadmin fixed server role on the Publisher or a member of the db_owner fixed database role in the publication database. If you are a member of the db_owner role, this error is raised if:
- You run scripts from previous versions of SQL Server. The security model has changed in SQL Server 2005, and these scripts must be updated.
- The stored procedure sp_addpublication is executed before executing sp_addlogreader_agent (Transact-SQL). This applies to all transactional publications.
- The stored procedure sp_addpublication is executed before executing sp_addqreader_agent (Transact-SQL). This applies to transactional publications that are enabled for queued updating subscriptions (a value of TRUE for the @allow_queued_tran parameter of sp_addpublication).
The stored procedures sp_addlogreader_agent and sp_addqreader_agent each create an agent job and allow you to specify the Microsoft Windows account under which the agent runs. For users in the sysadmin role, agent jobs are created implicitly if sp_addlogreader_agent and sp_addqreader_agent are not executed; agents run under the context of the SQL Server Agent service account at the Distributor. Although sp_addlogreader_agent and sp_addqreader_agent are not required for users in the sysadmin role, it is a security best practice to specify a separate account for the agents. For more information, see Replication Agent Security Model.
User Action
Ensure you execute procedures in the correct order. For more information, see How to: Create a Publication (Replication Transact-SQL Programming). If you have replication scripts from previous versions of SQL Server, update these scripts to include the stored procedures and parameters required by SQL Server 2005. For more information, see How to: Upgrade Replication Scripts (Replication Transact-SQL Programming).
See Also
Concepts
Cause and Resolution of Replication Errors