Cloud Storage Setting getting " The remote server returned an error (400) Bad Request

hpatel

Hi
trying to setup cloud uploads to Azure Storage account but getting
" The remote server returned an error (400) Bad Request"

petey2

On the machine where the SQL Server instance is running, open the folder where SQL Backup is installed e.g.

C:\Program Files (x86)\Red Gate\SQL Backup 10\<instance name>\

Open the file named log4backup.config.  Change the restrictedToMinimumLevel setting to debug.

Now open a command prompt window and navigate to the same folder.  Run the following:

sqbhostedstorageclient.exe authorize --instance <SQL Server instance name> --azure "<Azure account name>" "<Azure access key>" "<blob container name>"

replacing <SQL Server instance name>, <Azure account name>, <Azure access key>, and <blob container name> with your values.

Run the command, and a detailed log will be generated in the C:\ProgramData\Red Gate\Logs\SQL Backup 10\ folder.  Send us that log so we can see where the authorization process is failing in detail.