Azure SQL Database
An Azure relational database service.
In the past I have received that error but once I update the SSMS with the latest version from here the error is gone. Can you try that?
Unable to connect to SQL databases
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 45%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUG%3C/text%3E%3C/svg%3E)
Udeshka Gunawardena
45
Reputation points
Hi
Suddenly I am unable to connect to our databases in Azure sql pool.
We have 3 separate databases. I am unable to connect to 2 of them. (via Portal as well as MS Management Studio tool)
Any suggestions on where to start troubleshooting?
Thanks
MSMS
Portal
Azure SQL Database
{count} votes
-
Udeshka Gunawardena 45 Reputation points
2024-02-09T18:09:39.9533333+00:00 Thanks for the quick response. We can try that. However, I am unable to connect even via Azure Portal. So, that makes me think this is something else than a version compatibility issue.
Sign in to comment
2 answers
Sort by: Most helpful
-
Alberto Morillo 35,401 Reputation points MVP Volunteer Moderator2024-02-09T18:05:25.4666667+00:00 -
Udeshka Gunawardena 45 Reputation points
2024-02-09T18:09:58.9333333+00:00 Thanks for the quick response. We can try that. However, I am unable to connect even via Azure Portal. So, that makes me think this is something else than a version compatibility issue.
-
Alberto Morillo 35,401 Reputation points MVP Volunteer Moderator
2024-02-10T02:22:27.51+00:00 If the database is no longer available even for applications, is it feasible for you to try to restore it from automated backups as a new database as a workaround. Then drop the database using PowerShell.
Sign in to comment -
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 79%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
RahulRandive 10,501 Reputation points Volunteer Moderator2024-02-10T04:44:26.64+00:00 Hi @Gunawardena, Udeshka
Please find about the mentioned error and troubleshooting steps in below document. There can be multiple causes that can contribute to this problem. https://learn.microsoft.com/en-us/troubleshoot/sql/ssms/error-click-databases-node#symptoms Thank you!