SQL Login with '@' in the name (e.g. emails) not working in Azure SQL Managed Instance

César 236 Reputation points
2021-05-06T15:39:57.377+00:00

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@keyman .com' or 'test@test ' can't.

I tried to add the instance name like this 'test@keyman .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

Azure SQL Database
{count} votes

Accepted answer
  1. Oury Ba-MSFT 9,566 Reputation points Microsoft Employee
    2021-05-11T16:51:36.173+00:00

    Hello @César Thanks for being patient while working on this. Could you please create a login like test@test @xxxxxxx.database.windows.net that should map. Please let us know if that works.

    If that helps please accept answer so it can be beneficial for others community members facing the same issue.

    Regards,
    Oury


0 additional answers

Sort by: Most helpful