Access denied when running scheduled job


#1

When running the backup manually by pressing the green “Run now” button, it runs fine. However, scheduling it to run 5 minutes later via scheduled job, it fails. Application hasn’t been closed between running the manual job and scheduled one.

Log:

1/16/2019 9:25 AM Starting scheduled job “DNEVNI” - “Full”. Computer “TRAKTOR”. App v.“12.1.3”
1/16/2019 9:25 AM Connecting to SQL Server: 2005 SP4 Express Edition. .\SQLEXPRESS
1/16/2019 9:25 AM The backup folder “C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Backup” has “404.751GB” free space. The temporary folder “C:\Users\Traktor\AppData\Local\Temp\Pranas.NET\SQLBackupAndFTP\backup” has “404.751GB” free space
1/16/2019 9:25 AM Backing up “.\SQLEXPRESS” SQL Server databases
1/16/2019 9:25 AM Getting maximum file size…
1/16/2019 9:25 AM The maximum file size: “4882.813GB”
1/16/2019 9:25 AM Failed to backup “GamaBase” database with “Full” backup type: One or more errors occurred. > Access to the path ‘C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Backup’ is denied.
1/16/2019 9:25 AM Failed to backup “GamaAccounts” database with “Full” backup type: One or more errors occurred. > Access to the path ‘C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Backup’ is denied.
1/16/2019 9:25 AM Cleaning up backups of “DNEVNI” job
1/16/2019 9:25 AM Job “DNEVNI” finished with “2” errors
1/16/2019 9:25 AM Sending job log to REDACTED
1/16/2019 9:25 AM Sending job log to REDACTED
1/16/2019 9:25 AM Sending report to ${https://sqlbackupandftp.com/weblog?jobid=2d6038a0-839a-4362-a990-37b449b2becb|Web Log}

Any ideas?


#2

Hi Gama_Studio,

Could you please try to use SQL Server Authentication at the connection settings and then go to the bottom of your backup job settings and click on the “Gear” button on the “Run this job as user” and specify a user from whom you can successfully run the backup job manually.

SQLBackupAndFTP

Sorry for the inconvenience.


#3

Fixed by creating a new user and granting all privileges in SQL


#4

Hi Gama_Studio,

Good news! Please feel free to contact us on any issues or concerns.