While starting to migrate my system from on-premises SQL to Azure SQL Managed Instances, I found out that SQL Logins are not working in Azure because they are email addresses, and no user seems to work with an '@' in the name. For example, an user with name 'test' can connect to the Managed Instance, but users like 'test@domain.com' or 'test@test' can't.
I tried to add the instance name like this 'test@domain.com@instanceName' with no luck.
Any workaround for this? Thanks in advance
P.S: I asked this in stackoverflow a month ago, with no answer