Better support for email address logins
I'm porting an application where users log into a web portal using their email address and password, which delegates authentication to SQL Server LOGINs.
In SQL Server this is fine, but in Azure SQL, the string after the @ sign is given significance as a server name and the user gets error 40532. To log in, they have to put 'firstname.lastname@example.org@servername' which is clumsy. Please can you make a "default server" configurable to fix this (i.e. so that @servername is implied in all login requests)?
Thanks for your feedback here. This behavior is by design. You’ve mentioned here the work around is one way. There are also new authentication mechanisms such as AAD https://azure.microsoft.com/en-us/blog/preview-azure-ad-authentication-7/
I’d be happy to talk offline with the engineers involved.
Ste Griffiths commented
To be clearer, I'm referring to this requirement, taken from https://msdn.microsoft.com/en-us/library/ms189751.aspx (section "Windows Azure SQL Database Logins"):
"SQL Server rules allow you create a SQL Server authentication login in the format <loginname>@<servername>. If your SQL Database server is myazureserver and your login is email@example.com, then you must supply your login as firstname.lastname@example.org@myazureserver."
I've written a short post about this problem: http://stegriff.co.uk/upblog/using-email-addresses-as-login-usernames-on-azure-sql