patternMinor
Replication Access denied in Replication
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?
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:
In dialog "permissions for "
All should be ok now, and to verify
- 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.