Making scheduled SQL Server database backups with the help of SQLBackupAndFTP you can face with some issues. Here we are going to discuss one of them. Let’s assume you created a scheduled database backup job and made all necessary settings, even clicked “Run Now” button to check the backup job and everything works perfectly. But when time comes to make a backup according to the schedule you receive the following error message:
10/10/2016 14:22:43 ERROR: Access denied for user "Server\User". Access to the path 'D:\SQLDATA\Backup\Adventureworks.bak' is denied. DETAILED LOG: 10/10/2016 14:05:01 Creating backup of Adventureworks to D:\SQLDATA\Backup (full) 10/10/2016 14:05:10 ERROR: Access denied for user "Server\User". Access to the path 'D:\SQLDATA\Backup\Adventureworks.bak' is denied. 10/10/2016 14:05:12 Delete temporary folder: "C:\Users\User\AppData\Local\Temp\Pranas.NET\SQLBackupAndFTP" 10/10/2016 14:05:13 ERROR: Job finished (With Errors) Sending report to email@example.com (SMTP)
10/10/2016 15:47:35 ERROR: Backup failed > "Adventureworks": Google Drive exception > Cannot save common external data of "csadfggtr34653-734g54-ret65-5443-dsf98nwe". Access to the path 'C:\ProgramData\Pranas.NET\SQLBackupAndFTP\Destinations\External' is denied. > Access denied for user "Server\User".
Access denied for user “Server\User” – Solution
The solution is very simple, all you need to do is to run SQLBackupAndFTP backup job from the current user. Follow this simple tutorial to do it:
- Open SQLBackupAndFTP backup job and click “Advanced backup schedule”
- Press “Set as Current User / Your personal account” link
- Click “Save & Close” to apply all new settings