Issue while creating a user in azure SQL server

Question

In my application I need to create a user with the email id in the azure Sql server. Eg: The email id is: [email protected] create user [email protected] with password '123131'

The user gets created but when I try to login with that user a message is shown. Cannot open server "gmail.com" requested by the login. The login failed Click here

The issue is with @. If I change it with some other character it works. Is there any alternative because I need to create user with the email id.

Any help would be greatly appreciated.

Answer 1

SSMS recognize @gmail.com as server name here, and the workaround is simple: Assuming your SQL database server name is testserver.database.windows.net and you have a user [email protected], in SSMS you should specify the username as [email protected]@testserver and that would work. This should also applies to JDBC and ODBC connections as well.