Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Replication Newbie Expand / Collapse
Author
Message
Posted Monday, March 4, 2013 6:16 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 7:21 AM
Points: 1,380, Visits: 2,698
Hi all

I have set up snapshot replication between 2 instances on the same server (For testing)

The snapshot job runs fine but the distribution job fails with error:
Unable to start execution of step 1 (reason: Could not get proxy data for proxy_id = 2). The step failed.

Publisher: SQL 2008 Ent Edition
Subscriber: SQL 2005 Std Edition

SQL Agent runs under the same account (Network Service) for both instances.

I had an identical setup between 2 2008 instances and there were no issues

Thanks

Post #1426204
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse