Post reply

Cannot see deployed Reports on Target Server

  • September 1, 2009 at 5:24 am

    #210386

    Hi

    I have created a report in Visual Studio and deployed it successfully on my target server.

    1-

    When I run the http:///Reports, I get the Home at the top page but cannot see any subdirectories.

    I can see my Report when I log on directly to the Reporting Services database.

    2-

    I cannot find the .rdl file on the server. I don't know where to look.

    3-

    When I try to view the report by right-clicking on the report in the Reporting Services database, it open IE but I get the following error:

    An internal error occured on the report server. See the error log for more details. (rsInternalError)

    Invalid object name 'ReportServerTempDB.dbo.PersistedStream'

    Sorry lots of questions ...

    Cheers

    Ludo

  • September 1, 2009 at 1:30 pm

    #1047784

    im not sure about the error your getting but it sounds like it might be a permissions issue.

    have you tried typing out the direct link to your report?

    here is an example of one:

    http://servername/Reports/Pages/Report.aspx?ItemPath=%2fFolderName%2fReportName

    Replace servername, foldername and reportname with yours.

  • September 2, 2009 at 3:45 am

    #1047997

    Hi

    I have tried this this morning but I get an error message:

    The permission granted to user are insufficient for performing this operation

    So you're absolutely right, it is a permission issue.

    I'll keep digging ...

    I'll make sure to post the solution when I find it!!

    Thanks

    Ludo

  • September 2, 2009 at 7:04 am

    #1048084

    you need to have a builtin/administrator login and give you access.

  • September 2, 2009 at 10:05 am

    #1048273

    I think that now I have all the privileges under the sun.

    I now need to re-attach the ReportingTempDB database.

    I'll do it tonight out of core hours as this is a Live instance.

    Ludo

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply