Unable to access unc shared folder remotely using pull subscription of snapshot replication

Cindy See 166 Reputation points
2023-01-05T10:32:13.933+00:00

What could be the possible causes for a pull subscription of snapshot replication unable to access the unc shared folder remotely but a pull subscription is able to access the unc shared folder and replicate successfully?
Where do I troubleshoot at the remote server of the folder?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,677 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,452 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
493 questions
Accepted answer
  1. Seeya Xi-MSFT 16,436 Reputation points
    2023-01-06T02:24:22.843+00:00

    Hi @Cindy See ,

    Please refer to this MS document: Distribution Agent Security. Here are the points I want you to notice.
    For pull subscriptions, the account must at minimum be a member of the db_owner fixed database role in the subscription database.
    The Windows account or SQL Server account used for the connection must:

    1. Be a member of the PAL.
    2. Have read permissions on the snapshot share.

    Best regards,
    Seeya

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Cindy See 166 Reputation points
    2023-01-10T05:49:42.477+00:00

    Hi Seeya, May I verify with you on the account that you referred in the earlier message is the local windows account of the remote publisher server(which is a publisher as well as distributor) or the local windows account of the subcriber server?

    If it is the local windows account of the remote publisher server, it is a member of PAL and have read permissions on the snapshot share.

    If it is the local windows account of the subscriber server, could you show me the steps? These two servers do not reside in the same domain. Thanks