View a report on our SQL server remotely

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>

Re: View a report on our SQL server remotely

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

Re: View a report on our SQL server remotely

Hi,

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

Re: View a report on our SQL server remotely

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