Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
The system cannot find the file specified
5 views
Skip to first unread message
Craig Taylor
May 27, 2010, 6:51:02 AM5/27/10
to
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
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
0 new messages