1

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:

-Publication

-Publisher

-Distributor

-PublisherDB

-ReplicationType

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

-DistributorLogin

-DistributorPassword

-DistributorSecurityMode = 0

-PublisherLogin

-PublisherPassword

-PublisherSecurityMode = 0

migrated from stackoverflow.com 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 clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.