BACKUP DATABASE permission denied in database ''. SQLSTATE = 42000

Support for desktop and server
1

Error

BACKUP DATABASE permission denied in database ‘master’. SQLSTATE = 42000
Database “model” not found
BACKUP LOG permission denied in database ‘msdb’. SQLSTATE = 42000

Cause

The Windows user being used by the Windows scheduler service (server services) does not have permission to access the databases.
This can happen if the SQL permissions have been changed.

Fix

  1. Try a manual backup. We believe that will succeed if the logged-in user is an admin equivalent.
  2. If that does work, change the Windows account used by the Windows service ‘server services’ to the same as the logged-in user.