Could Not Import Package…Unable to connect to target server

When trying to import a local SQL database to an Azure SQL Database using SQL Enterprise Manager you can see this error. This is a know issue on Enterprise manager and nothing wrong with your database or connection.

To resolve you need to use a different tool to migrate your database which you can fine here: https://www.microsoft.com/en-us/download/details.aspx?id=53595

 

Leave a Reply

Your email address will not be published. Required fields are marked *