• Config SSRS on DB server
    • Service Account: Network Service
    • Report Server Mode: Native
    • When change setting: use sysadmin account (SQLAdmin) on the DB server
  • Reporting as s_tfsreports (Since we are running reporting service on DC, we will have to use domain admin account for this. Same for Background Job Agent)
  • Reporting rebuild:
    • From TFS Admin Console -> Reporting
    • Once rebuild, it will wipe out all existing reporting data warehouse and SSAS cubes and build them from scratch
    • Other than initial build, use this when warehouse or cubes mismatch with DB (especialy when manually change DB directly sometimes)
  • Setup Report Builder permission
  • Setup Data Warehouse permission – so some users can generate their own reports from Excel grabbing data directly from the warehouse
  • Setup Reporting service permission from the reporting site
Advertisements