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.

Hello · Accepted Answer · 2017-02-13 07:15:02Z

6

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.

answered Feb 13, 2017 at 7:15

Hello

6527 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Issue while creating a user in azure SQL server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related