Access denied for user “Server\User”

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 admin(SMTP)
or the following
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:

  1. Open SQLBackupAndFTP backup job and click “Advanced backup schedule”Access denied for user "Server\User"
  2. Press “Set as Current User / Your personal account” linkAccess denied for user "Server\User"
  3. Click “Save & Close” to apply all new settings
[Total: 1    Average: 5/5]

Leave a Reply

Your email address will not be published.