Replication security information you need to know with SQL Server 2008
I was able to install SQL 2008 July CTP as a Virtual Image, tried to test few replication tasks to know what has been changed since last versions. At this time I would like to use the replication scripts from SQL 2000 version to see what it takes, nothing much I believe compared from 2005 to 2008.
While going this replication security process gone through the excellent article by Paul Ibison about Replication Proxies, Credentials and Subsystems. Further I would like to highlight the enhancement within 2005 and 2008 going forward, as compared to SQL 2000. Replication enhancements include a separate Windows login that you can set up for each job. The Windows login/user can be assigned only the needed rights to complete the job. With SQL Server 2005, it is possible to change the replication password in one place for a single SQL Server. The process has been improved with SQL Server 2005's replication ability to automatically resume the process from the failure point without having to resend the completed data.
Somehow I was unable to work with replication scripts created in SQL 2000 within 2008 instance, then eventually found this Replication Agent Security Model information that has cleared many doubts of mine and further prepearations to perform changes on those scripts. Replication scripts created from SQL Server 2000 should be upgraded for SQL Server 2008 to take advantage of security enhancements. For more information, see How to: Upgrade Replication Scripts (Replication Transact-SQL Programming).