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:
- Restarted my web site's server (also tried iisreset and restarting the web app)
- Removed all IP filters in Azure portal (including access from Azure services)
- 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.