Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
share|improve this question

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

 
discard

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

Browse other questions tagged or ask your own question.