"Hilary Cotter" wrote:

> Locate your snapshot share. Do that by issue the following on your
> distributor
> sp_helpdistributor
>
> The name of your snapshot share should be in the directory column.
>
> Also on your publisher in your publication database do this
>
> sp_helppublication 'pubs' -- where pubs is your publication name
>
> Note the value for alt_snapshot_folder column. If this value is null your
> snapshot share is the value for the directory column returned by
> sp_helpdistributor. If it is not null the snapshot share is in the
> alt_snapshot_folder column.
>
> Using file explorer navigate to this folder and right click on it, select
> sharing and security and then make sure that the account which the sql
> server agent account runs under has read and list files and folders rights
> on this folder. The share permissions are by default always read.
>
>
> --
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "byteman" <byteman@discussions.microsoft.com> wrote in message
> news:9E69C2AD-9AA6-4B12-8B1A-B118123E9F3D@microsoft.com...
> > Hi, i have the following problem:
> >
> > i have a publisher and a subscriber in the same sql server 2005 machine.
> > All
> > the process (the Log Reader Agent and the Snapshot Agent) works fine. Even
> > the snapshot files are being created in the UNC path (\\Desa5el1\Paso),
> > but
> > when attempt to run synchronization, the Replication Monitor show me an
> > error
> > in the Subscription. When i see the details of the error, i see the
> > following:
> >
> > Error messages:
> > The process could not read file
> > '\\Desa5el1\Paso\unc\DESA5EL1$CASCABEL_MC_AREASQL_PUB_MC_AREASQL_PRUEBA\20070719170351\prueba_2.pre'
> > due to OS error 5. (Source: MSSQL_REPL, Error number: MSSQL_REPL20024)
> > Get help: http://help/MSSQL_REPL20024
> >
> > The account under which the agent runs is db_owner (is an sql account, not
> > an Windows account) and member of the Publication Access List. I think
> > maybe
> > the problem it is in this:
> >
> > "Have read permissions on the snapshot share."
> >
> > Could someone explain me this point? i need to configure some thing extra?
> > some permissions to the unc path?
> >
> > I really appreciate any help.
> > --
> > Thanks in advance
> >
>
>