Failed to Restore an Azure SQL Managed Instance Database from Azure Blob Storage

If you encounter issues while restoring an Azure SQL Managed Instance database from Azure Blob Storage, ensure that the database backup file is stored correctly in Azure Blob Storage.

Error: 1

‘Unable to open backup device’https://mystorageaccount.blob.core.windows.net/test_container/db_backup/mytest_db_01.bak‘. Operating system error 86 (The specified network password is incorrect.)

RESTORE DATABASE terminates abnormally.

Cause of failure

Blob storage credentials are incorrect or missing.

To verify your credentials

Although we’re leveraging managed identities, the same approach applies to all identity types. SQL Managed Instance Managed Identity Storage Contributor and Storage Blob Data Contributor It is required.

select * from sys.credentials

To create credentials

USE master
GO
CREATE CREDENTIAL [https:// mystorageaccount.blob.core.windows.net/db_backup/]
WITH IDENTITY='Managed Identity'
GO

Error: 2

‘Unable to open backup device’https://mystorageaccount.blob.core.windows.net/test_container/db_backup/mytest_db_01.bak‘. Operating system error 12007 (Failed to retrieve text for this error. Reason: 317)

RESTORE DATABASE terminates abnormally.

Cause of failure

Public network access for storage accounts is disabled and relies solely on private endpoints. However, the private endpoint was misconfigured or associated with an incorrect DNS zone, causing connectivity issues. A private endpoint for Blob storage must be created using: privatelink.blob.core.windows.net Private DNS zone.

To verify your private endpoint DNS configuration

Go to Storage Account > Network > Private Endpoint > Click Private Endpoint > Settings > DNS Configuration.

• FQDN: mystorage.privatelink.blob.core.windows.net
• Private DNS zone: privatelink.blob.core.windows.net