I have hit a road block while trying to setup merge replication using SQL Server 2008 R2 Express. I have the publication working fine. from a test computer with standard SQL Server 2008 R2 installed, I can synchronize with a pull subscription.
The Database server is windows 2008. We have an active directory with Windows 2003 DCs.
I have configured the laptops to synchronize while connected to the LAN. I was tying to avoid the additional complexity if Internet Synchronization
I was uable to get the pull subscription to work with SQL Server 2008 Express, so I set up an identical laptop with the standard version of SQL Server and was able to synchronize both from the Management Studio and from the front-end application.
The problem seems to be with the disabled SQL Server agent in the Express version
The agent job is never created from the SQL Studio or from the published code I used to create the subscription and agent job.
The error I get when I try to sync in code is:
merge_job_login update with value DOMAIN\MyRepAgent failed
the specified job does not exist.
MyRepAgent has all the rights I could give that login. I set that account up and used it as the login account of the SQL Agent Service on both laptops.
Is there a step by step article or white paper anywhere about setting up pull subscriptions u
View Complete Post