SSRS CONFIGURATION

Hi 

I configured my sql server reporting services, but I am getting error like this

"The permissions granted to user 'Rajesh-PC\ASPNET' are insufficient for performing this operation. (rsAccessDenied) Get Online Help"

I am using windows 7 ultimate and I have sql server enterprise 2008 R2

Any help will be greatly appreciated. 

Try running the browser as admin.

Thanks a lot mike for replying me..es I tried everything including running browser as admin. Still prob is unsolved..

Does this happen when you try to view the reports through IE? If so, here is something else you may want to try...

1. Start Internet Explorer
2. Tools > Internet Options
3. Security Tab
4. Trusted Sites
5. Click "Sites"
6. Uncheck "Require server verification (https:) for all sites in this zone"
7. Add http://ServerName

Hi shawn

Thanks a lot for your time..I tried your suggetion too but the problem is same. May be something wrong with my OS.

Hi shawn

Thanks a lot for your time..I tried your suggetion too but the problem is same. May be something wrong with my OS.

Try turning UAC off then restart your PC.  That usually does the trick.

I got the same problem.I followed the following steps.

1.Web Service URL and Report Manager URL corrected by using Reporting Services Configuration Manager

2.Run Internet Exploree As 'Run As Administratior'

3.In Internert Explorer go to Tools | Internet Options | Security Tab | Trusted Sites | Add http://localhost in trusted sites.If https check box is checked uncheck that one

4. Run report Manager

like http://localhost/Reports_Sql2008

i hope the problem will be resolved

You may have something interfering with the default port 80.  Try changing it to port 8080 in the Reporting Services Configuration Manager.

I am having the same kind of problem.  In Internet Explorer (run as Administrator), I added http://localhost as a trusted site. In Reporting Services Configuration Manager, changed the port from 80 to 8080. When I try to access the http://localhost/reports, I get the following error:

User 'Tompk-PC\Tompk' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.

Thanks.

If you set the port to 8080 you will need to use http://localhost:8080/reports

I should back up and tell you that I have Reporting Services working on one computer withSQL Server 2005 and on another machine we have SQL 2008 installed.  When I went into Reporting Services configuration manager we set the web Service URl for theTCP Port from 80 to 8080.  I also changed the Report Manager URl Urls: to http://Tompk-PC:8080/Reports.  After these changes are applied,

I go to Internet Explorer and enter http://localhost:8080/Reports and after entering my user name and password I am get: User "Tompk-PC\Tompk' does not have required permissions.  Verify that sufficient permissions have been granted and windows user account control(UAC) restrictions have been addressed.    Do you have any further suggestion to assist with this problem.

At this point all the suggestions you have gotten are about all that would cause this issue. I would go back and check them all again. Try turning UAC completely off.

Verify that you are an administrator on the rs box. If you are not and you don't want to go that route, you'll need to run IE as an administrator with permissions to the RS instance. One the administrator is logged in, you can explicitly permit your user account with permissions to view the HOME directory. If you are going to be an administrator on the RS server, I pesonally would add you as a system administrator in site settings. Please keep us posted.

Brian

Thank you all very much, I am moving along.  When I changed the UAC setting to never notify that seems to have solved the problem when I ran internet explorer as administrator. As long as the UAC setting was never notify, it didn't matter what setting I had for the port in Reporting Services configuration manager.  This fixed the issue for accessing http://localhost/reports through Internet Explorer.

However, I think that we would not want to leave this UAC setting on the default to notify us when changes are being made to the computer. I can understand that we may need to do this when we are updating items in Report Server temporarily, but the same issue exists for our Visual Studio 2008 .NET 3.5 Windows application is getting an error "The permissions granted to user 'Tompk-PC\Tompk' are insufficient for performing this operation. (rsAccessDenied)" when we are performing SetParameters for the report that is being viewed. When the UAC setting is set to never notify, the report is viewed with no problems. Do you have any suggestions if we need to keep the UAC setting at the default?

Thank you all very much, I am moving along.  When I changed the UAC setting to never notify that seems to have solved the problem when I ran internet explorer as administrator. As long as the UAC setting was never notify, it didn't matter what setting I had for the port in Reporting Services configuration manager.  This fixed the issue for accessing http://localhost/reports through Internet Explorer.

However, I think that we would not want to leave this UAC setting on the default to notify us when changes are being made to the computer. I can understand that we may need to do this when we are updating items in Report Server temporarily, but the same issue exists for our Visual Studio 2008 .NET 3.5 Windows application is getting an error "The permissions granted to user 'Tompk-PC\Tompk' are insufficient for performing this operation. (rsAccessDenied)" when we are performing SetParameters for the report that is being viewed. When the UAC setting is set to never notify, the report is viewed with no problems. Do you have any suggestions if we need to keep the UAC setting at the default?

I determined how to fix the issue for Visual Studio 2008 .NET 3.5 Windows application getting the rsAccessDenied error above and still be able to set the UAC setting at the default level. The following are the procedures that fixed the problem for me (the procedures where taken from SQL Server 2005, but very similar for SQL Server 2008):

<!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:1; mso-generic-font-family:roman; mso-font-format:other; mso-font-pitch:variable; mso-font-signature:0 0 0 0 0 0;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-520092929 1073786111 9 0 415 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin-top:0in; margin-right:0in; margin-bottom:10.0pt; margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} .MsoPapDefault {mso-style-type:export-only; margin-bottom:10.0pt; line-height:115%;} @page WordSection1 {size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.WordSection1 {page:WordSection1;} -->

1)    1) Access IIS to setup the Report Server and Report Manager in the Default Web Site listing:

a.       Make sure logged in as Administrator

b.      Click Start, run Inetmgr, and then click OK.

c.       In Actions panel on the right side, click View Sites.

d.      Highlight Default Web Site and under Actions panel click View Applications.

e.       Under Actions panel, Add Application …, (did this for Reports and ReportServer)

                                                              i.      Alias: Reports

                                                            ii.      Application Pool: ReportServer

                                                          iii.      Physical Path: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager

                                                          iv.      Click OK

                                                            v.      Add additional Application...

                                                          vi.      Alias: ReportServer

                                                        vii.      Application Pool: ReportServer

                                                      viii.      Physical Path: c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer

                                                          ix.      Click OK and close out of inetmgr

2)    2) Add the URL of Report Manager to the "Local intranet" security zone. To do this, follow these steps:

a.       In Control Panel, double-click Internet Options.

b.      In the Internet Properties dialog box, click the Security tab.

c.       On the Security tab, click Local intranet, and then click Sites.

d.      Check only Automatically detect intranet network (which was the default)

e.       Click Advanced

f.       Under Add this website to the zone, type http://localhost, and then click Add.

g.      Click OK and close out of Internet Properties

3)   3) Create role assignments that explicitly grant you access together with full permissions in Report Manager. To do this, follow these steps:

a.       Click Start, point to All Programs, right-click Internet Explorer, and then click Run as administrator.

b.      In the User Account Control dialog box, click Continue.

c.       Open Report Manager by using the URL of Report Manager. (http://localhost/reports)

d.      On the Home page, click Properties.

e.       Click New Role Assignment.

f.       Type a Windows user account name by using the following format:
Domain\User
Ex: TOMPK

g. Click to select the Content Manager check box, and then click OK (click apply if option is available).

h. On the Home page, click Site Settings.

i. Click Configure site-wide security.

j. Click New Role Assignment.

k. Type a Windows user account by using the following format:
Domain\User
Ex: TOMPK

l. Click the System User check box, and then click OK (click apply if option is available).

After the above options were set, I was able to open the report (contained in Reporting Services) from the Visual Studio 2008 windows application.

Thank you to everyone for assisting in this resolution.

Shawn,

Brilliant! This helped me and saved my time too.

Shiv