Aborted the task because of a task failure or an overlap with your preferred backup window for RDS automated backup. Access Denied

While checking the status of backup from the following view we are getting the error as follows:

exec msdb.dbo.rds_task_status

Error while checking the status:

2023-02-03 12:20:22.097] Task execution has started. [2023-02-03 12:20:22.507] Aborted the task because of a task failure or an overlap with your preferred backup window for RDS automated backup. [2023-02-03 12:20:22.510] Task has been aborted [2023-02-03 12:20:22.513] Access Denied

Cause: we are not added S3 storage permission in the role. So we need to add the permission of S3 storage with backup permission. For S3 we assign the AmazonS3FullAccess permission policy to the ROLE.

Solution: Add the S3 policy to the role which having awsbackup permission. Then associate with the database with option group to use this permission role.

You can refer link to create role, option group and associate the option group with database: Procedure msdb.dbo.rds_backup_database, Line 120 [Batch Start Line 9] Database backup/restore option is not enabled