This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 19%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
Hi,
I'm trying to set up SQL Server Transactional Replication, but I'm encountering an "Access Denied" error during the Snapshot Agent's operation. The replication process is supposed to create a snapshot of the database, but it fails with the following error:
Error messages:
Source: mscorlib
Target Site: Void WinIOError(Int32, System.String)
Message: Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\ReplData\unc\DESKTOP-3UGIOTT_CAMPUSNET2_PUB_CAMPUSNET\20240824192740' is denied.
Stack: at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.Directory.InternalCreateDirectory(String fullPath, String path, Object dirSecurityObj, Boolean checkHost)
at System.IO.Directory.InternalCreateDirectoryHelper(String path, Boolean checkHost)
at Microsoft.SqlServer.Replication.Utilities.CreateDirectoryWithExtendedErrorInformation(String directory)
at Microsoft.SqlServer.Replication.Snapshot.SnapshotProvider.CreateSnapshotFolders()
at Microsoft.SqlServer.Replication.Snapshot.SqlServerSnapshotProvider.GenerateSnapshot()
at Microsoft.SqlServer.Replication.SnapshotGenerationAgent.InternalRun()
at Microsoft.SqlServer.Replication.AgentCore.Run() (Source: mscorlib, Error number: 0)
Get help: http://help/0
I've checked the permissions for the directory in question (C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\ReplData) and made sure that the MSSQLSERVER service has full control. However, the error persists.Steps Taken So Far:
Verified folder permissions for MSSQLSERVER and SYSTEM accounts.
Tried restarting the SQL Server Agent and the Snapshot Agent.
Checked the SQL Server Agent log for additional details.
I'm looking for guidance on how to resolve this "Access Denied" error so that the Snapshot Agent can successfully create the snapshot and proceed with the replication process.
What about the permissions for NT Service\SQLSERVERAGENT?
So, I am trying by transactional replication to synchronise 2 databases and I have added for each database as user the NT Service\SQLSERVERAGENT and added them as db_owner for each database that needs to be synchronised.
USE CampusNet;
ALTER ROLE db_owner ADD MEMBER [NT SERVICE\SQLSERVERAGENT];
USE CampusNet2;
ALTER ROLE db_owner ADD MEMBER [NT SERVICE\SQLSERVERAGENT];
ALTER SERVER ROLE sysadmin ADD MEMBER [NT SERVICE\SQLSERVERAGENT];
As you see, I have also added as a sysadmin.
Am I missing something?
Hi @kevin stani ，
Any update for this tread? Did the reply could help you? If the response helped, do "Accept Answer". If it is not 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.
Hi @kevin stani
Any update for this tread? Did the reply could help you?
Hi,
I think the issue is solved, but I think it might be another issue, if you can help?
The publisher is finally Ok.
But the subscription provide me this error below:
Hi @kevin stani Thanks for your update.
Please create a new ticket for new issue. This will make this thread more readable and help people has the similar issue. More people will moted the new thread and I will continue help you. Thanks for your understanding.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(124.80000000000001, 53%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESY%3C/text%3E%3C/svg%3E)
The account has full permissions to that folder but getting access denied error
Hi @sandeep yuvaraj,
This is an old thread. Please create a new ticket for your issue. Share us more information about your issue to make us better understand your environment. More people will note the new thread, and I will continue help you. Thanks for your understanding.
Hi @kevin stani ,
Please check your SQL server agent service account and make sure that account has the full permission on this folder. Which account that you specify to snapshot agent? Does this account has the full permission for this folder?
If the answer is helpful, please click "Accept Answer" and kindly upvote it.
Hi,
Can you please tell me, to check on how I can see if the SQL Server agent service account has full permission on this folder? What I have done until now is:
USE CampusNet;
CREATE USER [NT SERVICE\SQLSERVERAGENT] FOR LOGIN [NT SERVICE\SQLSERVERAGENT];
USE CampusNet2;
CREATE USER [NT SERVICE\SQLSERVERAGENT] FOR LOGIN [NT SERVICE\SQLSERVERAGENT];
USE CampusNet;
ALTER ROLE db_owner ADD MEMBER [NT SERVICE\SQLSERVERAGENT];
USE CampusNet2;
ALTER ROLE db_owner ADD MEMBER [NT SERVICE\SQLSERVERAGENT];
ALTER SERVER ROLE sysadmin ADD MEMBER [NT SERVICE\SQLSERVERAGENT];
I have checked this 'NT SERVICE\SQLSERVERAGENT' in SQL Server Configuration Manager and in Windows Services to me they look Ok, maybe I am missing something
Those commands fairly meaningless. NT Server\SQLSERVERAGENT is already sysadmin in SQL Server.
Furthermore, the error you get is a permission error in Windows. The permissions and roles in SQL Server have nothing to with the rights in the Windows file system. So you need to check the permissions for the NT Service\SQLSERVERAGENT on the folder for the snapshot files.
Hi @kevin stani ,
Please follow below steps to check the snapshot agent service account, and the permission of snapshot files.
1.Right click transaction replication under Local publication as below screenshot, choose properties. Find the agent security as below screenshot.
If the answer is helpful, please click "Accept Answer" and kindly upvote it.
Hi, this is what is showing until now, with the same issue, should I configure the SQL Server Agent in some way or have I put the wrong object in the Repldata, and if yes, can you tell me to put the right object? As for info, I am using the windows authentcation, I haven't created any SQL Server authentication, it is all windows authentication for the both databases.
If something else is needed to be provided by me, please let me know and thank you for your help
Ok, your snapshot agent running under SQL server agent service account. Please check which account that running SQL server agent from sql server configuration manager. Make sure this account has the full control permission on the replica folder.
Share the screenshot like your last post is better for analysis.
The last should be the right one.
If I click Find now, I do not find the SQL Server Agent or 'NT Service\SQLSERVERAGENT'
Please follow below steps:
If the answer is helpful, please click "Accept Answer" and kindly upvote it.