Import into Azure - Could not import package, Unable to connect to target server

Question

I have a database and I want to move it to Azure SQL. While doing that, I have successfully exported the BACPAC file to Azure container. But, while importing it throws an error:

Error encountered during the service operation. Could not import package. Unable to connect to target server.

Can anyone help me with this?

Answer 1

In order to import, first of all you need to select the source file from the container and then you need to provide the SQL Authentication to login to your SQL server which you want to import.

I hope this will help.

Want to become an Azure Expert? join azure certification now!!

Want to know more about Azure SQL? Watch this video on Deploy SQL Database in Azure :