How to resolve "ErrorMessage: The storage account cannot be accessed. Please check the storage account name and key and try again."

Brett Miles 21 Reputation points
2022-08-29T05:22:37.317+00:00

I'm trying to archive a demo database that I've got. I've created a storage container but when I try and run the export command it fails with the following error:

Database export error
Failed to export the database: FMS_Demo.
ErrorCode: 400
ErrorMessage: The storage account cannot be accessed. Please check the storage account name and key and try again.

Any help on how to resolve this would be appreciated

Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
2,675 questions
0 comments No comments
{count} votes

Accepted answer
  1. Manu Philip 16,966 Reputation points MVP
    2022-08-29T06:26:37.97+00:00

    As the first step, check if there is any firewall/network restrictions applied in the storage account. Visit the following section and make sure that the settings is allowing the db to access the storage account

    235628-image.png

    ----------

    --please don't forget to upvote and Accept as answer if the reply is helpful--

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Brett Miles 21 Reputation points
    2022-08-30T01:26:40.783+00:00

    Hi Manu. Thanks, that did work however "enabled from all networks" doesn't sound particularly desirable. I had it set to "Enabled from selected virtual networks and IP addresses", had added my client IP address to the firewall and even tried setting the resource types and exceptions as per the screenshot below. What am I doing wrong that would not allow this to work?

    235878-image.png