Connect to Microsoft Azure Storage

APPLIES TO: yesSQL Server yesAzure SQL Database yesAzure Synapse Analytics (SQL DW) yesParallel Data Warehouse

Use the Azure Storage Connection dialog to specify a storage account and validate your connection to Azure.


Specify the following information about your Azure account, and then click Next to continue.

  1. Storage Account - Specify the storage account name.


You can only connect to General-purpose Storage Accounts. Connecting to other types of storage accounts can result in an error similar to the following:

The value for one of the HTTP headers is not in the correct format. (Microsoft.SqlServer.StorageClient).

The remote server returned an error: (400) Bad Request. (System)

  1. Account Key - Specify the account key for the specified storage account.

  2. Use secure endpoints (HTTPS) - This option utilizes encrypted communication and secure identification of a network web server.

  3. Save account key - This option saves your password in an encrypted file.