To create a user/group that can log into Report Manager and do
everything, create the user/group, then do the following:

1. Log into Report Manager as the admin user (or whatever name you gave
to the admin user).
2. Click "Site Settings" in the top-right corner
3. Under Security, click "Configure Item-level role definitions"
4. Name the Role and assign it to all of the tasks (click OK when done)
5. Click on "Site Settings" again
6. Under Security, click "Configure system-level role definitions"
7. Click "New Role"
8. Name the Role and assign it to all of the tasks (click OK when done)
9. Click "Site Settings"
10. Click "Configure Site-wide security"
11. If your user/group is already listed, click "Edit" next to it,
otherwise click "New Role Assignment" then type in your user/group name
on the next screen
12. Select the checkbox next to the system role you created in steps
6-8 (click Apply when done)
13. Click "Home" in the top-right corner
14. Click on the blue "Properties" tab
15. If your user/group is listed, click "Edit" next to it, otherwise
click "New Role Assignment" and type in your user/group name on the
next screen
16. Select the checkbox next to the role you created in steps 3-4
(click Apply when done).
17. Click Home. The end.

There are two different types of roles: item-level roles and
system-level roles. My guess would be that something was missing from
your list of 'tasks' in the item-level roles assigned to the
group/user. If you follow these instructions, you should end up with a
user/group that can do everything. This should help you determine if
it's a matter of permissions settings or something wonky with your
server setup. FYI, I would recommend against giving your users full
control over everything as described here.

I hope this helps.

Tim Larson

I am wondering what to look for on the server-level setup to address this issue. We have created accounts through the Reporting Services interface that have every permission possible, and we are still seeing this error message when the staff members generate a report through the report builder. They are accessing the report via link because we've been unable to get the button to appear. We have the data source configured to use stored credentials, but the error message we are seeing references the logged in user as the account with insufficient permissions.

From http://www.developmentnow.com/g/115_2006_6_0_0_780761/IUSR-Machine-account-permissions-in-Report-Builder.htm

Posted via DevelopmentNow.com Groups