How do disconnect to Azure SQL database if I can t access it

Question

We had migrated to AzureSQL V12 and after a few hours my website went offline, because of a persistent issue with the following message:

Resource ID : 3. The LoginLimit limit for the database is 90 and has been reached. See 'http://go.microsoft.com/fwlink/?LinkId=267637' for assistance. (Microsoft SQL Server, Error: 10928)

I have already tried the following:

1. Restarted my web site's server (also tried iisreset and restarting the web app)
2. Removed all IP filters in Azure portal (including access from Azure services)
3. Upscaled to the next tier in Azure (it is stuck on "In Progress" and not changing, so I guess the connections are preventing the upscale)

Still, I can't connect to my database via SSMS as I get the same error message. This has lasted for hours now, and my site is completely offline, yet the number of logins is not changing.

I need some way to disconnect some of these connections so I can get on and diagnose what the issue might be.

Answer 1

Based on info  from Microsoft, I think there might be a problem with the automated backups dropping connections to the database. If I ever hear more, I'll post an update, but in the meantime I would suggest that it might be prudent to disable any backup jobs you might have prior to upgrading/changing tiers of your SQL Azure instance.