Actually i configured Transactional replication on SQL 2019 developer edition but i getting below error. I am gave all permission to folder but is show again this error
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Has your problem been resolved? If you have any doubts, please feel free to let us know. If you find the answer helpful, please do "Accept Answer".
The SQL AGENT account needs to have access to the folder, not the SQL Server account.
Please see:
https://learn.microsoft.com/en-us/sql/relational-databases/replication/security/replication-agent-security-model?view=sql-server-ver15#permissions-that-are-required-by-agents
I am gave all permission to folder but is show again this error.
First of all, here is
Troubleshooter: Find errors with SQL Server transactional replication
.
Yes, this should be a permission issue.
You'll need to verify permissions to the folder where your snapshot is stored(according to your error path), and make sure that the account used to run the Snapshot Agent has permissions to access the share.
You can check the permissions of the file user again from the following steps:
1.Right click shared folder and click properties
2.Go to Advanced Sharing > Permissions In dialog "permissions for "
3.Add snapshot user
4.Grant "Full Control" All should be ok now, and to verify
Finally, this is a troubleshoot with some screenshots and examples, which is similar to the previous Microsoft document, I hope this is useful to you.
https://codingsight.com/troubleshooting-sql-server-transactional-replication-issues/
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.
Hi there,
When you configure the Microsoft SQL Server service to run under an account that does not have sufficient privileges on the SQL Server installation folder, SQL Server does not start, and it returns an error message, depending on how you try to start the service.
You can try the resolution explained in this forum
https://learn.microsoft.com/en-us/troubleshoot/sql/admin/event-id-7000-access-denied
-------------
--If the reply is helpful, please Upvote and Accept it as an answer--
