SSRS 2016 for Report Writers Setup

Instructions

Note: Changing any of the preferred settings will mean that students will lose precious class time reconfiguring data sources and other files to point to the proper instance or file location.

  1. Installation of SQL Server 2016 (or later) Enterprise or Developer Edition with the following features configured:
    1. Relational database engine (default instance preferred)
    2. SSAS multidimensional mode (default instance preferred)
    3. SSRS configured in native mode
    4. Install SQL Server Management Studio (SSMS)
    5. Install SSDT for VS 2017 https://go.microsoft.com/fwlink/?linkid=2132817. VS 2017 was used for development and testing of the courseware. Newer versions of the tool have a much more complicated installation and a lot more bugs, and require more frequent restarts of the application.  
  2. Update your version of Windows and SQL Server with the most recent updates, and then turn off auto updates.
  3. Student accounts should have local admin privileges.
  4. Download the classfiles and extract them to the C drive.  Once extracted, the path should be C:\Classfiles\SSRSforRW\Chapter x, etc.
  5. Restore the AdventureWorks,  AdventureWorksDW, AdventureWorksLT databases from the C:\Classfiles\SSRSforRW2016\Databases folder to the relational SQL instance.
    Note: These are not the standard AdventureWorks databases.  Small changes have been made to better demonstrate some report concepts.
  6. Restore the AdventureWorksMD database to the SSAS multidimensional instance.
  7. Add the service account user for SSAS to the relational engine security logins, and add it to the sys admin role.
  8. Deploy SSRS test project found in the C:\Classfiles\SSRSforRW\Setup folder and verify that the report is on the Report Portal.