Completely different cause and resolution to this problem for me:

When I grant sysadmin to my SSRS login it resolves the issue (obviously not a solution). Double-triple-quadruple checked all RSExec role...

SQL Noob (5/30/2008)

---

i personally try to avoid temp tables

i've seen people populate them with tens of thousands of rows and in many cases most of a source table they are...

"...may cause performance issues due to the locking of the tempdb while the temporary table is being created"

Is it possible to use table hints to alleviate this issue?