I'm trying to configure a new replication with SQL Server 2012
- I configured the distribution
- While configuring the publication, it asked for a user to run the snapshot agent. I set a strong user with the right permissions to the snapshot folder.
Now I'm getting the following error:
A required privilege is not held by the client. The step failed. – SQL Job Fails with error
The snapshot worked when changing the the SQL agent account to local system, but for security reasons, I need to run the SQL agent with a specific Windows account.
How can I resolve this issue?