Thanks for the ideas Luke...I haven't checked the logs...we do have it locked down well...but I will take a look at the link....more later.

Yeah, that's the first thing we checked. The credentials are there and everything checks out when we run the report through the ReportManager. It only prompts us for credentials coming...