HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Replication Access denied in Replication

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
deniedaccessreplication

Problem

I have a database on-prem, and I have an Azure account.

I need to establish transactional replication from the on-prem to Azure.

First of all I created a publication and after that I made a subscription to it.

Then I went to the publication and started the job.

It gives me the following error.

Any solution for that?

Solution

I had the same problem and solved with the following steps:

  • Right click shared folder and click properties



  • Go to Advanced Sharing > Permissions


In dialog "permissions for "

  • Add snapshot user (\repl_snapshot in my case)



  • Grant "Full Control"


All should be ok now, and to verify

  • Go to "View Snapshot Agent status" and click start, you should now see something like "[100%] A snapshot of 1 article(s) was generated."

Context

StackExchange Database Administrators Q#163252, answer score: 3

Revisions (0)

No revisions yet.