Migrated SSRS reports are not visible on the browser

• datsun

  SSCrazy

  Points: 2397

  More actions

  October 4, 2019 at 11:08 am

  Go to Answer

  #3685972

  Hello,

  I upgraded one SQL 2008 SSRS report on a new server SQL 2016.

  Opened the report in VS-2017 SSDT and Deployed it locally. It did the upgrade successfully.

  I changed the Deploy parameters to SQL 2016.

  But I can't see the report in new SQL server Reporting Server page. it's empty.

  http://localhost/Reports/browse/

  Any thoughts?

  need to repeat the process for all other SSRS reports (20+).

  Thank you,

  Vinay

• datsun

  SSCrazy

  Points: 2397

  More actions

  October 4, 2019 at 4:13 pm

  Answer

  #3686091

  To all with similar issue,

  I resolved it finally.

  1. From the Reporting Services Configuration manager change the Service account to Network Service. (it will ask for Backup key. Set one in a folder with a complicated password.)
  2. from the VS-SSDT 2017, under the Project properties of the Report, go to Configuration manager and click on both Build and Deploy. The configuration dropdown I selected Production.
  3. ensure the TargetServerURL is pointing to: http://localhost/ReportServer
  4. ensure the TargetServerVersion is set to 2016 or higher and the targetReportFolder has the actual foldername of the Report.
  5. Go back to localhost/reports and you will see the reportname there.
  6. to access the report outside the server (but within the office network) just replace the localhost to the Servername on the browser.

  regards

  V