Issues importing data-tier application to Azure SQL server

Question

I am trying to import a .bacpac of a local sql database to my Azure SQL Server using SSMS, but it fails with the message

Error SQL72014: .Net SqlClient Data Provider: Msg 15063, Level 16, State 1, Line 1 The login already has an account under a different user name. Error SQL72045: Script execution error. The executed script: CREATE USER [abc] FOR LOGIN [abc];

As far as I am aware, the login I am using is the server admin account and is the only account on the server. Is the problem created by the fact that I have a user in the database with the same name at the server admin account? Can anyone explain what I am doing wrong here?

Answer 1

Could you please change the owner on the database on-premises to “sa” and generate the bacpac again?

My recommendation is to use Data Migration Assistant instead of importing a bacpac. It is the easiest way to migrate databases to Azure SQL Database. You can download it here.