This post is part of SCCM Current Branch Installation Guide series
In this post we are going to Install & Configure SQL Server 2017 Reporting Services.
SQL Server Reporting services is no longer part of SQL Server installation. Download the setup from here.
You can download and install Reporting Services in just few minutes. Since the installer is specific to Reporting Services, you can now install the latest version of Reporting Services or the latest update and be certain it’ll have zero impact on your SQL Server databases or other SQL Server features.
Installation of SQL Server 2017 Reporting Services
Once downloaded, launch the setup. Click on “Install Reporting Services”
Enter the product key if you have one, for this occasion I am selecting free edition (valid for 180 days)
Click on few other pages to complete the installation.
Once installation is complete, click on “Configure report server“.
This will launch “Report Server Connection” page with auto created instance name as SSRS. Click on Connect
Once connected, select “Service Account“, and select existing Service account you want to use for SSRS. I am going to select existing account svc-sccmadmin created previously. Click on apply and make sure task is completed successfully.
Click on “Web Service URL”, specify any Virtual Directory name of your choice, I have selected default name as “ReportServer“. Click on apply and make sure task is completed.
Click on “Database“, and select “Change Database” to create new report server database.
Under “Change Database” window, select “Create a new server database” and click next.
Specify SQL Server name along with the instance name, provide the name “SCCM01\InstanceSCCM” as created previously and click on “Test Connection” to make sure Test Connection is succeeded.
Under “Database”, provide the database name of your choice, I am selecting default name as ReportServer,
Under “Credentials“, you will be able to see service account you used previously, click on next to continue
under “Summary“, verify all the information provided and click next to continue.
Next page will show successful configuration of Report Server Database Configuration with all parameters as success
Click on “Web Portal URL” to specify Virtual Directory which will be used as Website URL for reports. I am selecting default name as ”Reports” and click on apply and verify the task getting completed successfully.
