Problem downloading the snapshot agent in a merge pull subscription.

Hello.

I've been having an error when downloading the snapshot agent from our Publisher.

The articles selected are all the tables and all the stored procedures.

The Subscription is created programmatically and so is the synchronization. When trying to synchronize for the first time and when the subscriber tries to download the snapshot I have the following error:

---

Error messages:
The schema script 'Distrito_2.sch' could not be propagated to the subscriber. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001)
Get help: http://help/MSSQL_REPL-2147201001
The process could not read file 'GESZif\unc\AFRODITE$SILVITEST_GESZIF_GESZIF\20070621182845\Distrito_2.sch' due to OS error 3. (Source: MSSQL_REPL, Error number: MSSQL_REPL20143)
Get help: http://help/MSSQL_REPL20143
The system cannot find the path specified.
(Source: MSSQL_REPL, Error number: MSSQL_REPL3)
Get help: http://help/MSSQL_REPL3

---

The snapshot folder is at c:\GESZifSnapshotFolder and the unc is \\Afrodite\Snapshot.

I'm getting a little desperate with this because we really need to propagate the schema changes around the subscribers.

Thanks in advance,

AVD

Has this ever worked before? Does agent account have the read access to your snapshot folder?

Gary

|||Hello Gary, thank you for your reply.

No, this has never worked before. When I was studying a way to implement replication I mostly used the management studio and management studio express. I created a database with backup/restore and put it at the client, so I disabled the initial snapshot when the error ocurred for the first time.

When you refer the agent account I suppose you mean the one at the Publication server (since SQLExpress doesn't have the SQL Agent)? Yes, it has full rights over the directory.

Best regards,

AVD
|||

Gary Chen wrote:

Has this ever worked before? Does agent account have the read access to your snapshot folder?

Gary

Ok, Gary i took your advice and found out that the permissions must be set for the UNC share and not the directory security.

After that it all worked wonders. Thanks for the help.

Problem Creating Publisher

Hello there
I have server who is declered as publisher and distributore already, and i
have already active publisher
Now i'm trying to create new publish for another database.
I get error 14294: Supply either @.job_id or @.job_name ti identify job
Where can be the problem?
Hi Oded,
from the looks of previous posts on the problem this usually occurs if there
are improperly dropped old publications on the server, or possibly restored
databases that had been published.
One option to try is to drop all publications (you can script the existing
ones so you can recreate them with the script if you like - do that by right
clicking the publication name in Enterprise manager then choosing the Script
command) - completely remove publishing and distributing from the server
using the wizard, then put it all back again.

Mary Bray [SQL Server MVP]
Please reply only to newsgroups
"Oded Kovach" <roygoldh@.hotmail.com> wrote in message
news:e$WwxDH0EHA.1452@.TK2MSFTNGP11.phx.gbl...
> Hello there
> I have server who is declered as publisher and distributore already, and i
> have already active publisher
> Now i'm trying to create new publish for another database.
> I get error 14294: Supply either @.job_id or @.job_name ti identify job
> Where can be the problem?
>