locked
Help running reportviewer on my website RRS feed

  • Question

  • User-201138418 posted

    I'm trying to view a report through my web application but I'm getting the following message:
    The permissions granted to user 'ATOM\HOU00PNOMS00$' are insufficient for performing this operation. (rsAccessDenied)

    However in IE8 if I enter the link to the page on the web server (http://hou00dbs001/ReportServer_IOMM00/Pages/ReportViewer.aspx?%2fATOM%2fReports%2fRPT100&rs:Command=Render) it shows the report.

    The web server is HOU00PNOMS00 and the database server is hou00dbs001

    Both servers are running WindowsServer 2008 R2 (64) and the database is:
    Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)   Apr  2 2010 15:48:46   Copyright (c) Microsoft Corporation  Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)

    I've installed Microsoft Report Viewer 2010 Redistributable Package on the web Server also.


    Here is my code:

    using System;
    using System.Collections;
    using System.Collections.Generic;
    using System.Configuration;
    using System.Data;
    using System.Linq;
    using System.Text.RegularExpressions;
    using System.Web;
    using System.Web.Security;
    using System.Web.UI;
    using System.Web.UI.HtmlControls;
    using System.Web.UI.WebControls;
    using System.Web.UI.WebControls.WebParts;
    using System.Xml;
    using System.IO;
    using Microsoft.Reporting.WebForms;
    using LMS2.components;

    public partial class ReportViewer : BasePage
    {
      protected void Page_Init(object sender, EventArgs e)
      {
        // Report pages need to disable partial rendering to eliminate JavaScript error that happens when the View Report button is clicked
        var ScriptManager1 = (ScriptManager)Page.Master.FindControl("ScriptManager1");
        ScriptManager1.EnablePartialRendering = false;
      }

     protected void Page_Load(object sender, EventArgs e)
     {
      lbPrintMsg.Visible = false;
      lbNoPrinter.Visible = false;

      if (!IsPostBack)
      {
       ReportViewer1.ProcessingMode = ProcessingMode.Remote;
       ServerReport sr = ReportViewer1.ServerReport;
       sr.ReportServerUrl = new Uri("http://hou00dbs001/ReportServer_IOMM00");
       sr.ReportPath = "/" + DatabaseName + "/Reports/" + Request.QueryString["PageID"];

       // Pack any query string values not PageID or NodeID off as report parameters
       List<ReportParameter> paramList = new List<ReportParameter>();
       foreach (string key in Request.QueryString.Keys)
       {
        if (key.ToLower() != "pageid" && key.ToLower() != "nodeid")
         paramList.Add(new ReportParameter(key, Request.QueryString[key]));
       }
       if (paramList.Count > 0)
        sr.SetParameters(paramList);

       ReportViewer1.PromptAreaCollapsed = (paramList.Count > 0);
       ReportViewer1.ShowPrintButton = false;
      }
     }
    }

    Friday, August 19, 2011 4:36 PM

All replies

  • User-201138418 posted

    I got it working with Report Server Credentials

    Friday, August 19, 2011 8:44 PM