SQL SERVER – Connecting to Azure Storage with SSMS

SQL Server Management Studio can now connect to Azure Storage.

It is very simple to connect to Azure Storage. First open the Object Explorer in SQL Server Management Studio (SSMS). Now click on Connect. Upon clicking on the connect it will bring up five options as displayed in the image below.

SQL SERVER - Connecting to Azure Storage with SSMS azureconnect1

Click on “Azure Storage” and it will bring up another screen asking for storage account and account key.

SQL SERVER - Connecting to Azure Storage with SSMS azureconnect2

Now go to your Azure account and get the name of the storage account, and account Key.

SQL SERVER - Connecting to Azure Storage with SSMS azureconnect3

It will bring up following screen.

SQL SERVER - Connecting to Azure Storage with SSMS azureconnect4

Enter the name of the account and account key at the prompt in SSMS.

SQL SERVER - Connecting to Azure Storage with SSMS azureconnect5

Once you enter the details, it will immediately connect you with your Azure Storage. Next, expand the node and you will notice your containers.

SQL SERVER - Connecting to Azure Storage with SSMS azureconnect6

The same containers will be visible in your Azure account online.

SQL SERVER - Connecting to Azure Storage with SSMS azureconnect7

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

Solarwinds
Previous Post
SQL SERVER – SSMS: Index Usage Statistics, Physical Statistics & User Statistics
Next Post
SQL SERVER – A Question on SSMS Prompt about Connect to Server

Related Posts

6 Comments. Leave new

  • Hi Dave, This is a good beginning but perhaps you could explain what you can do once connected. You show the container names but can you see the filenames? I use Blob storage to backup and would like to see the files through SSMS rather than having to use Azure explorer.

    Reply
  • I agree what can we do by connecting this way?

    Reply
  • Hi Dave,

    i am not able to connect to Azure Storage within my Company network and getting following error any idea how to resolve this?. Thanks in advancec.

    The server encountered an unknown failure: the remote server returned an error: (407) proxy Authentical required. (Microsoft.SQLserver.storageclient)

    Reply
  • I’m getting back a 400 Bad Request response

    Reply
  • Looks like you can only connect to storage accounts that are of the general purpose account kind. You can’t connect via SSMS to the Blob storage account kind.

    Reply
  • Connecting is nice but other than seeing the containers and the items inside, you can’t do anything with them. Can’t even export/download them or view the contents (even if the contents are text like a web or SQL log file). Pretty much useless right now.

    Reply

Leave a Reply

Menu