October 24, 2007 at 1:53 pm
We're using SQL 2005 Reporting Services. The Reporting Services is configured to use Integrated Windows Authentication in IIS.
The problem is the filter dropdown does not populate in Report Builder for any user other than the Administors group user. It throws an error "The requested list could not be retrieved because the query is not valid or a connection could not be made to the data source. " The report runs when user manually enters the value in the filter, so it must be able to connect to the data source. It's just the filter list does not populate.
It populates fine once we add the user to the server Administrators group, but we can't add all the report builder users to the server Administrators group.
What did I miss? Anyone experienced the same problem?
Thanks,
Sarah
October 30, 2007 at 9:40 am
For anyone who's intereted in this topic - I finally figure out how to get it working. It's really easy but costed me valuable time to test around.
I just need to grant the user 'browser' rights at the home page in report manager, and it works fine. Don't know why I have to do this but I'm happy now since I don't have to sacrifice the security much. Basically I only grant permissions at the lower folder level and code the URL at various applications and save the data source at the folder level too.
Sarah
October 31, 2007 at 11:09 am
Sarah
Be careful with this approach. All data sources should be in one location on the server. In the future databases will move and you can go to one place in report manager and change your data source.
This is just how I built my report manager.
1. Under Home directory (Hidden)
Shared Data source (each report will use data source from this directory)
2. Create groups on the box itself (this is too handle security) - didn't want to create groups in the AD
3. Create folders
Financial reports - visible (browser privs) - for each group built
4. Create hidden folders
For your reports
From these reports you will create linked reports. So, if you need to update them you can in one spot.
Well, I hope this helps.
Michael
November 7, 2007 at 2:11 pm
Also make sure you check the permissions on the SQL database side for the user. 😀
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply