View a report on our SQL server remotely RSS

• • Reply
  

  rossman308

  Member

  349 Points

  119 Posts

  View a report on our SQL server remotely

  Jan 02, 2012 05:45 PM|LINK

  I am trying to open a page with a report viewer on it and I get

  The request failed with HTTP status 401: Unauthorized.

  All I am trying to do is view a report on our SQL server remotely. This page works in VS2010 but fails when we try to browse it. Nothing on the MS page tells how to configure a website so it can see a report on the report server.

  Thanks

  <div id="MainReport">
          <asp:ScriptManager ID="ScriptManager1" runat="server">
          </asp:ScriptManager>
          <rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" CssClass="ReportControl"
              ShowCredentialPrompts="false" ShowParameterPrompts="true" ShowToolBar="true"
              Font-Size="8pt" InteractiveDeviceInfos="(Collection)" ProcessingMode="Remote"
              BackColor="White" ForeColor="red" WaitMessageFont-Names="Verdana" WaitMessageFont-Size="14pt"
              Height="1000px" Width="900px">
              <ServerReport ReportPath="/AAA2/QualifiedInfoReport" ReportServerUrl="http://ssi-sql/ReportServerAAA2" />
          </rsweb:ReportViewer>
      </div>

• • Reply
  

  Srikanth Kas...

  Contributor

  4289 Points

  883 Posts

  Re: View a report on our SQL server remotely

  Jan 03, 2012 03:45 AM|LINK

  Rossman,

  Did you pass the credentials  to the report viewer ? if not, please pass on the credentials to report server.

  Refer this :

  http://srikanthkasturi.webs.com/apps/blog/entries/show/8662369-ssrs-reports-with-net

  Regards
  
  Srikanth Kasturi
  Please "Mark As Answer" if my post serves purpose.
  • Marked as answer by rossman308 on Jan 03, 2012 01:39 PM
• • Reply
  

  Horizon_Net

  Star

  8277 Points

  1435 Posts

  Re: View a report on our SQL server remotely

  Jan 03, 2012 10:58 AM|LINK

  Hi,

  like Srikanth said your problem should be the credentials. This thread might help you.

  Regards.
  
  If my post solves your problem, please mark as answer.
  • Marked as answer by rossman308 on Jan 03, 2012 01:39 PM
• • Reply
  

  rossman308

  Member

  349 Points

  119 Posts

  Re: View a report on our SQL server remotely

  Jan 03, 2012 01:39 PM|LINK

  I have looked for this solution for three days. For all of
  the articles that tell you how to drop a report viewer control into and ASP.net
  page none even mention the necessary relationship  between ProcessingMode="Remote “ and the
  authentication issue or  how to  resolve it.

  Both of you gentle men are incredibly brilliant and I thank you
  for your help.

  Happy New Year!

  Ross

  • Edited by rossman308 on Jan 03, 2012 01:39 PM
  • Edited by rossman308 on Jan 03, 2012 01:39 PM