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.
| Author |
Topic |
|
Craig Taylor
Starting Member
2 Posts |
 Posted - 2010-06-02 : 07:04:28
|
| HiI 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 ProcessNumber: -2147221502Message: The system cannot find the file specified.2010-05-27 05:00:01.508 Category:NULLSource: Merge ProcessNumber: -2147199373Message: 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:NULLSource: Merge Process(Web Sync Client)Number: -2147010889Message: 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.ThanksCraig |
|
|
|
|
|
The system cannot find the file specified