Cannot open server requested by the login

Question

I'm trying to connect to my Azure SQL database using pyodbc. The azure account that I am using is under the username [email protected] (my university account). When I try to connect to the database, I get the error

Cannot open server "student.bham.ac.uk" requested by the login. The login failed. (40532).

The credentials that I am using are correct. The error makes me think that it might be confusing my login for the database server? What does this error mean and how can I fix the issue?

Answer 1

This seems to work for me:

If your SQL Database server is called myazureserver and your login is [email protected], then you must supply your login as [email protected]@myazureserver.