SSRS 2017 Fresh Install

  • HappyGeek

    SSCoach

    Points: 18661

    First I know this is the wrong place but SSRS 2017 does not appear as yet, so........

    Fresh install on SSRS, build 14.0.600.1274, all went well until trying to trying to connect and then get the error (from the logs\) "Could not find stored procedure 'GetAllFavoriteItems'" and beyond that stuck, any ideas?

    ...

  • Site Owners

    SSC Guru

    Points: 80385

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • pietlinden

    SSC Guru

    Points: 62394

    Does 'GetAllFavoriteItems' exist in your current restored database? Sounds like it can't find it.

  • HappyGeek

    SSCoach

    Points: 18661

    Thanks for the reply, by fresh install I mean brand new on new server, the database is newly created. Compared with an existing report server installation it appears to have 48 missing stored procedures within the ReportServer database, the GetAllFavoriteItems is the first and only one reported in the RS logs. I know I could simply try copying them from another database and seeing if that works but the question remains as to why this has happened and why should I need to "Fudge" a clean install.

    Essentially something seems to have gone wrong but there is no indication of that during setup, the error is only manifest when running the web portal.

    ...

  • Sue_H

    SSC Guru

    Points: 89970

    You shouldn't need to kludge anything on a clean install. The first thing to check would be the logs from the installation - default location is C:\Program Files\Microsoft SQL Server\nnn\Setup Bootstrap\Log. There would be the summary.txt file and (sometimes) an error.txt file. Go through the summary and look for any warnings or errors. There should also be a file that ends with ComponentUpdateSetup.log which is specific to Reporting Services. Those logs may give you some idea of what may have gone wrong.

    Sue

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

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