Network ip address required to allow to be able to export to Storage account
- Dominant language
- Python
- Stars
- 4.6k
- Forks
- 3.5k
- Avg merge
- 3d 2h
- Merged PRs (30d)
- 60
Description
I am trying to export to Blob Storage. It works fine when the blob storage has no network access restrictions. As soon as I enable network restrictions, I get the following error. I have tried to add the IP of the sql database server and the IP of the management API:
40.68.37.158 and 65.52.129.125 (which I had to add to the database ip filtering to be able to remove the first error message I got).
"There was an error that occurred during this operation : '<string xmlns="http://schemas.microsoft.com/2003/10/Serialization/">Error encountered during the service operation. ; Exception Microsoft.SqlServer.Management.Dac.Services.ServiceException:Unexpected exception encountered while retrieving metadata for blob 'https://xxxxxxxxxx.blob.core.windows.net/dumps/filename2020-03-16 145918 591.bacpac'.; Inner exception Microsoft.WindowsAzure.Storage.StorageException:The remote server returned an error: (403) Forbidden.; Inner exception System.Net.WebException:The remote server returned an error: (403) Forbidden.; </string>'"
Could you please point me in the right direction for what IP that should be allowed for the Blob Storage Export operation to work?
BR
Mikael
---
#### Dokumentinformation
⚠ *Redigera inte det här avsnittet. Det krävs för docs.microsoft.com ➟ länkning till GitHub-problem.*
* ID: c1bdd674-b454-e863-c943-9c979b466a92
* Version Independent ID: b15341f9-3f1b-00e0-a1c2-970f25a6ab03
* Content: [az sql db](https://docs.microsoft.com/sv-se/cli/azure/sql/db?view=azure-cli-latest#feedback)
* Content Source: [src/azure-cli/azure/cli/command_modules/sql/_help.py](https://github.com/Azure/azure-cli/blob/dev/src/azure-cli/azure/cli/command_modules/sql/_help.py)
* Service: **sql-database**
* GitHub Login: @rloutlaw
* Microsoft Alias: **routlaw**
Contributor guide
Assessment
This issue has not been assessed yet.