Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a Windows Server 2008 R2 install running SQL Server 2008 R2 with all the latest updates etc applied,

I have restored a database from an old image (SQL 2005) and am trying to get web-sync working with merge subscriptions.

However when I attempt to start the SQL Snapshot Agent on the distribution I have defined I get this error:

Unable to start execution of step 2 (reason: Error authenticating proxy SERVER-NAME\Administrator, system error: Logon failure: unknown user name or bad password.). The step failed.

I am starting the agent as the computer admin and am not using a proxy server.

Any ideas on why this might show up?

See below:

enter image description here

The params used by the SQL Snapshot agent are:






If you are using SQL Server Authentication (I am), you must also specify the following arguments:



-DistributorSecurityMode = 0



-PublisherSecurityMode = 0
share|improve this question

migrated from Jun 24 '11 at 18:23

This question came from our site for professional and enthusiast programmers.

Can you post the parameters from step 2 of the job? Be sure to mask any passwords. – mrdenny Jun 24 '11 at 18:37
Hi @mrdenny, I have attached a screenshot above, All I am doing is right clicking the publication, clicking view snapshot agent status and clicking start and I am confronted with that. – Myles Gray Jun 24 '11 at 19:13
Can you edit the SQL Agent job which is what actually runs the Replication agent and show those properties? – mrdenny Jun 27 '11 at 22:27
Hi @mrdenny, see above, I have added what params are needed by the snapshot agent, I can find the procedure too if needed? – Myles Gray Jun 28 '11 at 8:34
Are those the only parameters which are specified in the SQL Agent job? – mrdenny Jun 28 '11 at 19:39

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.