The system cannot find the file specified

Discussion in 'microsoft.public.sqlserver.replication' started by Craig Taylor, May 27, 2010.

  1. Craig Taylor

    Craig Taylor Guest

    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
     
    Craig Taylor, May 27, 2010
    #1
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.