• Sometimes when I have this issue, I start SQL Server Profiler and add the following events from the Errors and Warnings category: Exception and User Error Message. With these two you'll see the permission denied errors and they will occur close to or next to the statement that the account tried to execute but failed. If you don't see the SQL it executed, you'll need to add events from the Stored Procedures or TSQL event categories.

    Hope that helps.