RE: OS error 53 for SQL servers VPN replication?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Rand Boyd [MSFT] (rboyd_at_onlinemicrosoft.com)
Date: 02/27/04

  • Next message: John Bell: "Re: Link to Oracle 9.2.0" 
    Date: Fri, 27 Feb 2004 17:50:12 GMT

    This error is generally caused by the fact that the SQL Server Agent
    startup account on either the publisher or subscriber is not a local
    administrator on one or both of the machines.

    The default location for the snapshot folder is an administrative share and
    as such the SQL Server Agent acount must be a local adminsitrator to access
    it. From the error I am going to presume that you are creating a pull
    subscription so the SQL Server Agent startup account at the subscriber must
    be a local admin on the publisher. You can verify if this is the problem by
    logging on to the subscriber using the SQL Server Agent startup account and
    try to map a drive to the snap shot folder on the publisher:

    \\MERCURY\G$\

    If that fails with the same error then you have your reason for the failure.

    Rand
    This posting is provided "as is" with no warranties and confers no rights.

  • Next message: John Bell: "Re: Link to Oracle 9.2.0"

    Relevant Pages

    • Re: OS error 53 for SQL servers VPN replication?
      ... The Distributor and Publisher SQL ... Server is in the NARC domain and Agent login account as NARC\Administrator. ... And the subscriber is in the HOT domain and Agent Login account is ... > This error is generally caused by the fact that the SQL Server Agent ...
      (microsoft.public.sqlserver.replication)
    • Re: OS error 53 for SQL servers VPN replication?
      ... The Distributor and Publisher SQL ... Server is in the NARC domain and Agent login account as NARC\Administrator. ... And the subscriber is in the HOT domain and Agent Login account is ... > This error is generally caused by the fact that the SQL Server Agent ...
      (microsoft.public.sqlserver.connect)
    • Re: OS error 53 for SQL servers VPN replication?
      ... > the NARC domain for HOT\Administrator if there's no trusted???? ... >> This error is generally caused by the fact that the SQL Server Agent ... >> startup account on either the publisher or subscriber is not a local ... >> subscription so the SQL Server Agent startup account at the subscriber ...
      (microsoft.public.sqlserver.replication)
    • Re: OS error 53 for SQL servers VPN replication?
      ... > the NARC domain for HOT\Administrator if there's no trusted???? ... >> This error is generally caused by the fact that the SQL Server Agent ... >> startup account on either the publisher or subscriber is not a local ... >> subscription so the SQL Server Agent startup account at the subscriber ...
      (microsoft.public.sqlserver.connect)
    • Re: Distributor SQLSERVERAgent Account
      ... your subscriber's sql server agent should be running ... under the same account as the publisher's SQL Server agent, ... that is part of the local admin group on the publisher. ... If this is not possible the SQL Server agent account on the subscriber ...
      (microsoft.public.sqlserver.replication)