'Cannot open server requested by the login
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?
Solution 1:[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.
Solution 2:[2]
I recently suffered this same problem and I fixed it this way:
- Go to your SQL Server resource on Azure
- Go to "Firewalls and virtual networks"
- Verify "allow Azure's service and resources accessing this server" is set as YES
Save changes and let up to 5 minutes to apply this changes.
Solution 3:[3]
What Hdot said works also 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.
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.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Hdot |
| Solution 2 | Gonzo345 |
| Solution 3 | shock_in_sneakers |