This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 78%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
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
Hello @César Welcome to Microsoft Q&A and Thank you for posting your question.
Which Migration tool are you using ?
Thank you for your answer.
I am not using any tools, I have my own tools to progressively migrate and I used to create logins like this:
CREATE LOGIN [user@domain.com] WITH PASSWORD = 'X', DEFAULT_LANGUAGE = Español;
CREATE USER [user@domain.com] FOR LOGIN [user@domain.com]
but in Azure I had to replace it with:
CREATE LOGIN [user..domain.com] WITH PASSWORD = 'X', DEFAULT_LANGUAGE = Español;
CREATE USER [user..domain.com] FOR LOGIN [user..domain.com]
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
Thank you for your answer. It works if I create the login including the sufix, but I was expecting to be able to keep logins as original emails. If this it's the only option, it's cleaner for me to replace the @ with 2 consecutive dots, as this solution is not attached to the instance name. Thank you.
CREATE LOGIN [test@test@**********.database.windows.net] WITH PASSWORD = 'X', DEFAULT_LANGUAGE = Español;
@César I am glad that resolve your issue.
Regards,
Oury
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 61%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EML%3C/text%3E%3C/svg%3E)
I have exactly same issue. I am trying to give BULK INSERT premission to myself and my user login as firstname.lastname@abc.com is not working. I am using this script 'GRANT ADMINISTER BULK OPERATIONS TO firstname.lastname@abc.com. Can you please help. The messge says "Msg 102, Level 15, State 1, Line 1 Incorrect syntax near '.' "