January 20, 2012 at 8:58 am
I have several SQL Server databases I've developed reports from in VS2005. I'm the admin on our system and can develop, deploy, and run dozens of my reports via our SQL report server. I can run reports from both the development and "live" enviroment. Deployment of my reports is straight forward. I always use windows integrated security on our network.
Logged into our network as myself (the admin) I can run reports and see all my data sources on the RS webserver. My users however see no data sources in any folders. When they run reports, errors generate returning "query execution failed for data set XYZ". All my users have proper permissions in the folder structure of the report server.
It appears my users cant "hit" my SQL Server datasources when they execute reports on my RS web server. How can i solve this challenge?
phunhog
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply