Came across this error while trying to restore a SQL database backup which was stored in a container to Azure SQL managed instance.
Operating system error 5(Access is denied.).
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3201)
The blob would connect properly and show the backup file.
Solution:
Deleted the stored credentials in the database and did the process again for restoring backup.
