"acsnaterse" <snaterse@gmail.com> wrote in message
news:1184079506.481076.126000@22g2000hsm.googlegroups.com...
>I have a transactional replication running and it's running well.
>
> But now i'm writing a script so I can start the Snapshot Agent from
> distance. therefore I want to run it from the command prompt.
>
> I'm using this command: C:\Program Files\Microsoft SQL Server\80\COM
> \snapshot.exe -Publisher <server> -PublisherDB <pubDB> -Publication
> <pub> -DistributorLogin <login> -DistributorPassword <pwd>
>
> And this is my output:
> ==== Output start ======
> Microsoft SQL Server Snapshot Agent 8.00.2039
> Copyright (c) 2000 Microsoft Corporation
>
> The process could not create file '\\<server>\ReplData\unc'.
>
> Finished with exit code 2
> ==== Output end ======
>
> When I start the agent from SQL Server itself it works fine.
>
> the location of the snapshot folder is defined as '\\<server>
> \ReplData' and (for testing now) this folder has full access.
>
> Can somebody tell mee what;s going wrong and what I can do about it?
>

On 10 jul, 17:58, Paul Ibison <Paul.Ibi...@Pygmalion.Com> wrote:
> Can you create your command as text in a batch file then use RunAs (or log on
> again if RunAs is disabled). The user to select is the sql server agent
> login...
> HTH,
> Paul Ibison