I am trying to transfer all logins part of an Azure SQL MI to another server. Have re-created the SQL logins with the help of 'sp_help_revlogin' script.

Learnt that AD logins needs to be created manually again, when I do so I am getting the following error

create login "abcd@xyz.com" from external provider

error: Principal 'abcd@xyz.com' could not be resolved. Error message: ''

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.