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

César 236 Reputation points

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 15,276 Reputation points Microsoft Employee

    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.


0 additional answers

Sort by: Most helpful