The system cannot find the file specified
in [Replication]
|
From: Craig Taylor on 27 May 2010 06:51 Hi I have set up SQL https replication to a remote site but getting the error below when the SQL scheduled job tries to run. I have another test subscription set-up in exactly the same way and it runs on schedule without any errors. I set up the subscription following this http://technet.microsoft.com/en-us/library/ms152511.aspx and other related tech net articles. The remote subscription is set to run under a specific local user account which is also set as a SQL login with the correct privileges. I can physically log-in as this user and run the subscription manually with no errors and I have installed the cert into the certificate store. I have also noticed if I log in as another user on the server and try and run the subscription manually I get the same error as below. But if I then run IE as the subscription user and access the replisapi.dll URL I can then run the subscription. It seems as though it cant access the certificate although it is installed for the subscription user. Any ideas? Source: Merge Process Number: -2147221502 Message: The system cannot find the file specified. 2010-05-27 05:00:01.508 Category:NULL Source: Merge Process Number: -2147199373 Message: The Merge Agent failed to connect to the Internet proxy server for user 'SQL_rep_agent' during Web synchronization. Ensure that the proxy server settings are correctly configured in Internet Explorer, or specify the -InternetProxyServer parameter when starting the Merge Agent. 2010-05-27 05:00:01.508 Category:NULL Source: Merge Process(Web Sync Client) Number: -2147010889 Message: The Merge Agent could not connect to the URL '...replisapi.dll' during Web synchronization. Please verify that the URL, Internet login credentials and proxy server settings are correct and that the Web server is reachable. Thanks Craig
|
Pages: 1 Prev: Rows Deleting after a FK violation at subscriber Next: Partition Replication |