locked
Cannot view SSRS 2008 R2 Reports RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Yesterday, I did a side-by-side install of SQL Server 2008 R2 (kept existing instance of SQL Server 2005 with SSRS active).

    I migrated all databases over to 2008 and installed SSRS on 2008.

    I was able to deploy reports successfully to 2008.

    My problem is that now my ASP.NET web application can't view the existing reports through ReportViewer (this was working fine in 2005).

    When I try to access reports from our beta site, the error message I keep getting is "HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly. "

    When I try to access the reports from my local development machine, I get "The request failed with HTTP status 401: Unauthorized".

    However, I AM able to access the reports directly from the report server URL.

    What am I missing?

    Wednesday, December 29, 2010 8:46 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    you need to use ScriptManager in sql server 2008 or 2008 r2! eg;
    <asp:ScriptManager ID="ScriptManager1" runat="server"> </asp:ScriptManager>
    <rsweb:ReportViewer ID="ReportViewer1" runat="server" Width="100%" Height="100%" BackColor="#B9DFDF" WaitMessageFont-Bold="True" WaitMessageFont-Italic="False" WaitMessageFont-Names="Verdana" WaitMessageFont-Overline="False" WaitMessageFont-Size="14pt" WaitMessageFont-Strikeout="False" WaitMessageFont-Underline="False"> </rsweb:ReportViewer>
    • Proposed as answer by Challen Fu Monday, January 3, 2011 6:22 AM
    • Marked as answer by Challen Fu Thursday, January 6, 2011 10:14 AM
    Thursday, December 30, 2010 1:34 AM