rsAccessDenied

Hello,

I am new to Reporting Services 2005, so please bare with me. I have set up a new report that runs fine when I run it, but I am the administrator on the server. When I have a user go to the same web page and attempt to run the report, they receive an error that says something along the lines of "User account 'DomainName\UserName' does not have sufficient access to ReportServer... rsAccessDenied." I have seen several threads on the web that point to IIS, and some that point to the "Reporting Services Configuration Manager" under "Windows Service Identity". In my Windows Services Identity, I have the server set up as "Built-in Account = 'Local System'". Everything seems to be running perfect for me, I just can’t seem to get non-admin accounts to run reports from there local workstations. Please let me know what my settings should be on the server. Like I said, the web page comes up fine for all users, but when they click on the hyperlink that runs the report, they receive the Reporting Services error message, but it runs fine for me. Your help would be greatly appreciated.

Thanks,

Stephen Rooker

use the following:

'rs.Credentials = System.Net.CredentialCache.DefaultCredentials

Dim LogonCredentials As System.Net.NetworkCredential

Dim Items As rs.CatalogItem

LogonCredentials = New System.Net.NetworkCredential("username", "password", "domainname")

rs.Credentials = LogonCredentials

rs.PreAuthenticate = True

|||

Thanks for your help. Here's what I did to fix this issue. I'll enter detail for any other developers out there that may come across this issue and need help.

In your internet browser address bar, enter http://ServerName/Reports . I did this from the server, but you may be able to do this from anywhere on the network as long as you have permissions. Select the Properties tab, and then click on New Role Assignment. Add network User Name or add your network Group in the text box. I recommend using network groups due to maintenance. I just entered the group name I wanted to allow access, and then I checked the Browser role check box only. The Browser role is basically run reports only. You may want to review what the other check boxes allow, but I only added my users to the Browser role and it worked for them. When finished, click the Apply button at the bottom of the page. The domain name was added for me automatically after I clicked Apply, so make sure you see your domain name in front of the user name or group after you click Apply.

Now go back to the Contents tab, select Data Sources, and then select your data source name. The data source that you used for your reports. In there, make sure all of the settings are correct. I needed to make sure the user name and password are correct so a successful data connection is made. Click Apply at the bottom of the page when finished.

Doing this fixed my issues with rsAccessDenied error message.

Thanks,

Stephen Rooker

|||Cheers mate you helped me fix my issue.