Failed to Restore SQL Managed Instance Database Backup from Azure Blob Storage by info.odysseyx@gmail.com October 19, 2024 written by info.odysseyx@gmail.com October 19, 2024 0 comment 18 views 18 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 Source link Share 0 FacebookTwitterPinterestEmail info.odysseyx@gmail.com previous post Common mistakes to avoid when writing proposals for NGOs – fundforNGOs next post Request for Applications: Citizen Fellowship Program (Pakistan) You may also like Ride-sharing and Robotaxis Decopled Revenue Model Problems February 17, 2025 Web Raiders run the Global Brut Force attack from 2.5M IPS February 12, 2025 Generator Tech, Robot, risk of emerging February 11, 2025 Robotaxis is bringing in the lift dallas’ with ‘2026 with’ February 11, 2025 Why did Qualcom lose his first leadership February 10, 2025 Lenovo’s ThinkPad X 1 Carbon has rewrite my MacBook Pro February 5, 2025 Leave a Comment Cancel Reply Save my name, email, and website in this browser for the next time I comment.