Gator-221056 (12/15/2009)
A shared datasource with SA credentials on a report server.... what's the worst that could happen? 😉While I understand the simplicity and brevity you were going for for the purposes of this article.... wouldn't it at least make more sense to grab the data with a job, dump into a repository and have the report just use read only credentials on that repository?
Just having an account be owner over MSDB didn't give you the data you needed?
I know that isn't the ideal situation from a security perspective. I tried various alternatives that didn't seem to work and I don't recall all of what I tried at this time. I do have a special account "ReportViewer" that I use for other reports that I was planning to get it, or maybe a different one, to work for this report when I have a chance.