Prepare To Install Reporting Services

Bradley Schacht is a Principal Program Manager on the Microsoft Fabric product team based in Saint Augustine, FL. Bradley is a former consultant, trainer, and has coauthored 6 SQL Server and Power BI books, most recently Learn Microsoft Fabric. As a member of the Microsoft Fabric product team, Bradley works directly with customers to solve some of their most complex data problems and helps shape the future of Microsoft Fabric. Bradley gives back to the community through speaking at events such as the SQLBits, Fabric Community Conference, PASS Community Data Summit, SQL Saturdays, Code Camps, and user groups across the country including locally at the Jacksonville SQL Server User Group (JSSUG). He is a contributor on SQLServerCentral.com and blogs on his personal site, BradleySchacht.com.




From the box that opens check each of the following bold items:
In Windows Server open the Server Manager, then on the left side expand Roles > Web Server (IIS) then click Add Role Services in the right pane.
You will see a series of check boxes come up, of which the following bold items need to be checked:
From this point on any system, you are ready to run the SQL Server Setup Wizard. Getting these setting is vital to having a working report server. A missing setting could cause errors down the road, anything from permissions issues, to an error message telling you the report server is not there, when you know for sure it is…because you installed it. During the install process you can chose the option to “Install the default configuration” or “Install but do not configure the server” which is completely up to you. Remember to install any service packs and updates after you complete the initial installation. In the next article in this series we will take a closer look at report server configuration including securing your report server with an SSL certificate.