This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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(246.4, 6%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJE%3C/text%3E%3C/svg%3E)
This morning I started getting an error stating that the session limit for the database of 4800 has been reached and I can no longer log into SQL Server Management Studio and the databases I have created that access the Azure SQL Server bring up the same error. Is there a way to kill all current sessions. What might have caused this? Any help would be much appreciated. Thank you!
![](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(252.8, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Hi @Jason Evans,
Just checking in to see if the below answer provided by @Erland Sommarskog helped.
If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
The reason that comes to mind is that you have an application running against this database, and this application close connections but leave them opening, leading to this error. Stopping this application, should solve this immediate problem. Then you need to review your application problem to solve the problems with the connections, so that it does not happen again.
Hi @Jason Evans,
Just checking in to see if the above answer provided by @Erland Sommarskog helped.
If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.