Cannot open server requested by the login

user_10622485 0
Viewed 10671

I'm trying to connect to my Azure SQL database using pyodbc. The azure account that I am using is under the username xxxxxx@student.bham.ac.uk (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?

azure-sql-database pyodbc azure python
3 Answers

This seems to work for me:

If your SQL Database server is called myazureserver and your login is user@example.com, then you must supply your login as user@example.com@myazureserver.

user_106224850

I recently suffered this same problem and I fixed it this way:

  1. Go to your SQL Server resource on Azure
  2. Go to "Firewalls and virtual networks"
  3. Verify "allow Azure's service and resources accessing this server" is set as YES

enter image description here

Save changes and let up to 5 minutes to apply this changes.

user_35639100

What Hdot said works also for me

If your SQL Database server is called myazureserver and your login is user@example.com, then you must supply your login as user@example.com@myazureserver.

but, worth to mention that if you use DBeaver, you must update USER and PASSWORD in 'Driver Properties' tab (instead of 'Main'). This can be really confusing. enter image description here

user_115235210
Related