SQL Server 2008 R2 Replication not working - my 1st try I am having difficulties when I attempt my first shot at SQL Server 2008 R2 Replication.
Looks like I have login issues.
How do you modify settings without having to start a new plan again?
Please be kind - this is all new to me ....... lol

It looks like I have a security problem:


  Access to path is denied
Your Snapshot Agent process account does not have sufficient permissions to access the snapshot folder.

In the section Permissions That Are Required by Agents in Replication Agent Security Model, the Snapshot Agent process account requires db_owner in the distribution and publication databases and needs read, write, and modify permissions on the snapshot share.

Have a look at Lesson 2: Preparing the Snapshot Folder for more information.