error VS403366 during azure devops server migration to cloud

Question

hi

during migration from on premise to cloud (tried 3 times) i get this :

Your import to 

VS403366: A problem occurred while attempting to connect to your database. Please verify that your connection string is correct and that all required IP addresses for Azure DevOps Services have been provided exceptions for your machine's firewall.

List of Azure DevOps Services IPs:

20.82.174.196

Provided Connection string: Data Source=disprodweu1.database.windows.net;Initial Catalog=DataImport_disprodweu1_faa088fe-43ae-4b7d-9d5a-6601a9ca4252;Integrated Security=False;User ID=tfsTPC-c476470c2144455e8174b94a7adc3284;Password=******;Connect Timeout=30;Encrypt=True

Exception details returned from your instance of SQL: Cannot open server 'disprodweu1' requested by the login. Client with IP address '20.166.41.4' is not allowed to access the server.  To enable access, use the Azure Management Portal or run sp_set_firewall_rule on the master database to create a firewall rule for this IP address or address range.  It may take up to five minutes for this change to take effect.

this is a small collection (dacpac file less than 5gb and db less than 10gb), so i didn't setup a dedicated sql vm here. what am i missing here?

thank you

Answer 1

@AzureUser2023 Azure Devops is not currently supported here on Microsoft QnA.

The Community Members and Engineers are actively answering questions in dedicated forums here. Please post your question in that forum:

https://developercommunity.visualstudio.com/spaces/21/index.html

https://azure.microsoft.com/en-in/support/devops/