Replication Security Enhancements

In SQL Server 2005, replication introduces a number of enhancements to security:

• Enhanced security granularity between agents. In previous versions of SQL Server agents ran, by default, under the context of SQL Server Agent. SQL Server 2005 allows fine-grained control over the accounts under which replication agents run and make connections: a different account can be specified for each agent. For more information, see Replication Agent Security Model.
  

  Important:
  Replication scripts created from SQL Server 2000 or SQL Server 7.0 should be upgraded for SQL Server 2005 in order to take advantage of security enhancements. For more information, see How to: Upgrade Replication Scripts (Replication Transact-SQL Programming).

• Agent passwords can be changed through agent properties dialog boxes and stored procedures. If you change the password for a Windows account or SQL Server login used by a replication agent, you can change all passwords stored by replication in one place. For more information, see How to: View and Modify Replication Security Settings (SQL Server Management Studio) and How to: View and Modify Replication Security Settings (Replication Transact-SQL Programming).