Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 The system cannot find the file specified

Author  Topic 

Craig Taylor
Starting Member

2 Posts

Posted - 2010-06-02 : 07:04:28
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
   

- Advertisement -