Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SQL server management studio - email address as login

Tags:

ssms

azure

I have an azure database I'm trying to connect to with my email address as the admin login. So in sql server management studio, the login prompt looks something like this:

enter image description here

When I attempt to login, I get an error:

Cannot open server 'something.com' requested by the login.

This is clearly not my intention. How do I get it to treat my email address as simply the login name?

like image 868
aw04 Avatar asked May 25 '16 18:05

aw04


1 Answers

Appending @servername to the login allows it to look for the proper server.

So in this case, the login becomes [email protected]@example.database.windows.net

like image 153
aw04 Avatar answered Sep 22 '22 14:09

aw04