SQL SERVER – Backup to Microsoft Azure Tool – ERROR: Account Verification Failed

I have been seeing many customers moving their SQL Server to Cloud. Few of them have chosen Microsoft Azure platform to host their production server and few others have selected other cloud platforms like AWS. When they host SQL in Azure, they can choose various backup methods. In this blog, we would learn about fixing an interesting error “Account Verification Failed” while using Microsoft SQL Server Backup to Microsoft Azure Tool.

This is a free tool from Microsoft which can be downloaded from the link here Microsoft SQL Server Backup to Microsoft Azure Tool

One of my clients has downloaded and installed it on the SQL Server Azure Virtual Machine. Here is how they were trying to configure. As soon as they launch, we get below screen.

SQL SERVER - Backup to Microsoft Azure Tool - ERROR: Account Verification Failed az-err-01

Click on “Add” and provide a backup path and file extension.

Solarwinds

SQL SERVER - Backup to Microsoft Azure Tool - ERROR: Account Verification Failed az-err-02

Hit next and provide storage account details.

SQL SERVER - Backup to Microsoft Azure Tool - ERROR: Account Verification Failed az-err-03

As soon as we click on “Verify account” we get an error – Account verification failed. This is not a very informative error as we have triple checked the account name, keys, and container multiple times.

WORKAROUND/SOLUTION

We used another account and it was working fine. Then we compared each property of both storage accounts and found that this was caused due to below setting – “Secure transfer required”. In good case it was disabled and in bad case it was enabled.

SQL SERVER - Backup to Microsoft Azure Tool - ERROR: Account Verification Failed az-err-04

Once we made it “Disabled” we were able to proceed.

SQL SERVER - Backup to Microsoft Azure Tool - ERROR: Account Verification Failed az-err-05

Have you encountered such error where there is no meaningful solution in the message? I hope Microsoft fixes it soon.

Another cosmetic issue: If you look at the tool installer and usage it says “Microsoft SQL Server Backup to Windows Azure Tool” whereas download link says “Microsoft SQL Server Backup to Microsoft Azure Tool”. This is something like what I blogged here SQL SERVER – SSMS 17.7 Observation – Two Miscellaneous Category in Database Property Options

Hope it would reach Microsoft team via this blog and they provide some meaningful error message.

Pinal Dave (https://blog.sqlauthority.com)

Solarwinds
, , , , ,
Previous Post
SQL SERVER – Unable to See SQL Server Configuration Manager. How to Open it?
Next Post
SQL SERVER Analysis Services – Unable to Start Service. Error: The Filename, Directory Name, or Volume Label Syntax is Incorrect

Related Posts

Leave a Reply

Menu