[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE permission denied in database ‘XXXX’.

Error

[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE permission denied in database ‘XXXX’.

Cause

  1. The user connecting does not have appropriate SQL permissions to access the database (scheduled backups use SQL authentication NOT Windows authentication).
  2. TCP/IP is not enabled on the SQL server.
  3. TCP/IP for the SQL server is not set to listen on the correct IP address.
  4. Mixed mode authentication is enabled on the SQL server.
  5. The SQL user’s password that the backup is triggering as may be expired

Resolution

  1. Grant appropriate backup privileges for the SQL user that CyberSecure is connecting to the SQL server as
  2. Enable TCP/IP on the SQL server
  3. Set the SQL server to listen on the correct IP address
  4. Enable SQL mixed mode authentication
  5. Disable password expiration on the SQL user login