Thanks. Yes I agree 🙂

We had the same issue and reserved set memory for SQL and left the rest as shared.

There also seems to be one possible solution on:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/b80d7f29-b271-4845-b7be-df5a9b591ed2/ssrs-2008-connection-failure-timeout-or-low-disk-condition-within-the-database?forum=sqlreportingservices

Quoted as follows:

"

Rich,...

Hi

Thanks. Easy and straight to the point.

How would you do it on a SQL cluster (active/passive)? Would you need to run it while each node is...

Just checking.  Are your 2005 services running as a local user? 

If this is the case change your linked server to connect as a domain user with relevent AD Query...

In "Object Explorer" (MS SQL Management Studio) Expand the [databasename] / Security.

Click on Schemas. 

In summary window, determine which Schema(s) are owned by the user and either change the...