I have an Microsoft Access application that uses an Azure SQL server. This has been running without any problems for many months.

Starting at the end of last week I’m getting the error:

ODBC Driver for SQL Server Resource ID : 2. The session limit for the database is xxx has been reached.

This stops all users of the database from being able to do anything.

I can see by using the sp_who proceedure in SQL Server Management studio that only some of the machines that the application is running on are generating large numbers of sessions that remain in a ‘sleeping’ state and are not being cleared.

Nothing in the application has changed recently and I assume that this has been caused by a Windows and/or Access update that was applied last week.

Any information about how to solve this issue would be greatly appreciated.