I'm receiving the following error when I run any of my reports: 'Failure sending mail: The report server has encountered a configuration error. Mail will not be resent.'
When I use the following query, I noticed that all of my subscriptions for a report was being ran by the user's id. But when I updated the username to 'BUILTIN\Administrators'. and reran it worked.
So this is telling me that if anyone creates a report, it's going to run as their username and not 'BUILTIN\Administrator'. How can I default all reports to be ran as 'BUILTIN\Administrators'?