Number Of Permitted Connections Exceeded

Sometimes you may receive an error message indicating that the number of permitted connections has been exceed. This is normally caused by sleeping processes on the SQL Server and your internal database administrator should be able to remove these for you.

To do this they should check in Enterprise Manager -> Local Server -> Management – > Current Activity -> Process Info.

Killing any of these sleeping processes should solve the problem.