Azure SQL Database Export Problem - "Enable Azure access"

Searchlight Admin 31

I have been doing a monthly export of my Azure SQL databases for years, but today I am receiving an error message when I try to export them.

The message is, "Enable Azure access on server xxxsqlserver1"

It appears that I now need to enable some kind of access to be able to export the database.

Can someone please tell me specifically how to do that?

Thanks!

M Watson 6 Reputation points

2022-08-01T18:05:30.137+00:00

I'm receiving the same error when trying to export a database to file storage when using the Azure portal even with Azure access enabled. Fortunately, there was a helpful message at the top of the page to "Enable access" which seemed to update firewall and allow the operation to complete.
Searchlight Admin 1 Reputation point

2022-08-01T18:10:26.403+00:00

Excellent!

Thank you very much. I didn't notice that before. It worked.
David Apelt 1 Reputation point

2022-08-01T22:50:33.383+00:00

It seems that I need to hold my breath when using Azure some days. Things that have always worked a certain way magically stop working. Thanks for the tip.

1 answer

Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator

2022-08-01T15:33:22.45+00:00
You can use the Azure Portal, you click on Export then you can click on below link to give access to the server:

Alternatively, you an try the following:

New-AzureSqlDatabaseServerFirewallRule -ServerName "SERVER NAME" -AllowAllAzureServices

You can use the Azure Portal too and on the Network settings of the Azure SQL logial server make a hek mark on "Allow Azure Services and resources to access this server"

Please make sure these settings are not part of the problem in that scenario. Setttings like "Deny public network acccess" are enabled.
Please sign in to rate this answer.
Searchlight Admin 1 Reputation point

2022-08-01T15:54:51.357+00:00

Alberto,

I appreciate your response.

Unfortunately, this does not appear to be the issue because I already have this exception item checked.

Any other thoughts?

Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator

2022-08-01T16:43:38.367+00:00

Please make sure this is not happening in that scenario.

Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2022-08-04T05:21:13.74+00:00

Thank you @Alberto Morillo

Hello @Searchlight Admin ,
Did you get a chance to check the document provided by Alberto? Please let us know if you have any further questions.

Ahmed Samy Mahmoud 21 Reputation points Microsoft Employee

2022-08-11T15:59:02.787+00:00

Hi @Searchlight Admin

There was a glitch in Portal and Product team rolled out a hot fix, this should be fixed right now.
Please check out and confirm back by marking this answer to Accepted
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Your answer