I'm having a problem where the users cannot see their folders is the report manager webpage.

I have RS setup on a server that is a domain controller. In the active directory users & computers, I setup an organization unit called REPORTING. In the REPORTING OU, I setup reporting groups and users. I assigned the users to the appropriate group. Then, I setup folders in the report manager webpage corresponding to the REPORTING groups. I clicked on the properties for the folder and was able to add a new role associating the folder to the reporting group (giving the users browser role). Everything seemed to work fine on the server. But, when the user logs in from their PC, he/she has no folders in the report manager.

Does anyone have any ideas on what I'm doing wrong?

Any info would be greatly appreciated.

Chris

Try making your users log off and log back on so that their security context is updated. When you first log in, you are give a token that contains all of your user and group information. They get that token when they first login, and your changes to the DC don't have any effect until they log in again. If this doesn't work for you, we will try again.....



Todd Bryant
MCSD,MCDBA,MCSE,MCT

Ok, I figured out how to fix part of the problem. I was trying to grant access to a folder called Accounting. I didn't realize that I had to grant access to the Home folder. Once I created a new role assignment for the Home folder, I was able to see the Accounting folder and the reports in that folder.

I have a new problem relating to permissions. When I run the report from the client, I get the following error message.

The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. (rsInvalidDataSourceCredentialSetting) Get Online Help

I tried running a report in the home directory and got the same error message. The data source is setup in the home directory using Windows NT Authentication (for both reports). I even tried using Credentials Not Required and got the same error message.

Any ideas on how I can fix this?

Chris

The report is probably using a shared data source. The data source is not updated automatically because it is shared. You must specifically update any changes that you make to the source. If you are using any caching or scheduling with the data, then you must provide credentials that will be used.

Todd Bryant
MCSD,MCDBA,MCSE,MCT