Tom Collins has troubleshooting tip for us:
Receiving a regular ” There is insufficient system memory in resource pool ‘default’ to run this query” message in the SQL Server Error logs, leading to unavailability of sufficien resources to connect.
This query supplied by Jonathan Kehayias is a great way to start assessing if there is SQL Server memory presure .
Click through for the query and some additional explanation.