Fixed my issue. I have to use a User account for the execution account and use SQL Login for all my reports connections.

My issues maybe more complicated than yours as I cannot even open the reports myself. I have full admin rights to the db. When I look in the security log...

I have similar issues. Keep getting the following error when I run the report in report manager. I have changed to use a SQL login with db_datareader and sysadmin rights...