When performing a MS SQL database backup (ODBC backup mode), the following warning message is received in the backup report:
|*||info||...||[Start] Backing up "SQL_hostname\MSDB\db_name" ... to "temp_path"|
[Microsoft][ODBC SQL Server Driver][SQL Server] Cannot open backup device
Operating system error 5 (Access is denied.).
The message suggests that there was a permission issue when attempting to access the temporary directory for storing backup files.
To resolve the issue, ensure that the folder configured for the Temporary directory for storing backup files setting can be accessed by the SQL Server (MSDB) service:
On the other hand, if the temporary directory is set to a network share, for SQL Server to access a remote disk, the SQL Server service account must have access to the network share. The availability of network drives and permissions depends on the context is which SQL Server service is running:
sql, odbc, temp, vss, access, denied, mssql