How to migrate data from Azure file storage to Azure SQL DB

Error I am getting Error 40615: Cannot connect to < servername

CodePudding user response：

• I tried to repro this and got the error 40615: Cannot open server

• Check the connection strings - server name, password, and database name.

• Add your client ip to the firewall. Below are the steps.

  1. Open the Azure SQL Database in azure portal.
  2. Click Networking

3. Click  Add a firewall rule

4. Add the client ip address. 
5. You can also check allow azure services and resources to access this server. This will allow all azure resources to access your database.

Reference: MS Document on IP firewall rules - Azure SQL Database and Azure Synapse Analytics