Enable Azure access on server

Question

Enable Azure access on server

Carolyn Schroeder 191

I have am trying to export a database to a backpak and am getting the message "Enable Azure access on server glqr7ajlfz."

I have tried to do this with the CLI command
az sql server firewall-rule create -g Default-SQL-CentralUS -s glqr7ajlfz -n azure --start-ip-address 0.0.0.0 --end-ip-address 0.0.0.0

and am still unsuccessful.

Please help!

1 answer

Your answer

Answer 1

Alberto Morillo 34,671 MVP Volunteer Moderator

Please try the following:

New-AzureSqlDatabaseServerFirewallRule -ServerName "SERVER NAME" -AllowAllAzureServices

You can also go to the Portal, select Export, then click on the link below.

Carolyn Schroeder 191 Reputation points

2022-08-01T20:01:17.197+00:00

When I try to run Add-AzureAccount I get a username/password dialog. I can enter my information but the PS command fails because it needs strong authentication.
Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator

2022-08-01T23:07:57.51+00:00

Try using the portal as shpwn on the image I shared on my answer
Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator

2022-08-02T00:38:42.39+00:00

Hi @Carolyn Schroeder Please follow the step suggested by @Alberto Morillo and let us know if that help.

Reference: Export to a BACPAC file - Azure SQL Database

Share via

Enable Azure access on server

1 answer

Your answer