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 a 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 firstname.lastname@example.org (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 “ServerUser” – Solution
You can get this issue because the user from which you try to backup database has not enough permissions.
The solution is very simple, all you need to do is to run SQLBackupAndFTP and go to the SQL Server connection settings, where it is necessary to specify the credentials for a user who has enough permission to work with selected databases.