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”

SSRS 01

Enter the product key if you have one, for this occasion I am selecting free edition (valid for 180 days)

SSRS 02

Click on few other pages to complete the installation.

SSRS 06

Once installation is complete, click on “Configure report server“.

SSRS 07

This will launch “Report Server Connection” page with auto created instance name as SSRS. Click on Connect

SSRS 10

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.

SSRS 12

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.

SSRS 13

Click on “Database“, and select “Change Database” to create new report server database.

SSRS 14

Under “Change Database” window, select “Create a new server database” and click next.

SSRS 15

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.

SSRS 16

Under “Database”, provide the database name of your choice, I am selecting default name as ReportServer,

SSRS 17

Under “Credentials“, you will be able to see service account you used previously, click on next to continue

SSRS 18

under “Summary“, verify all the information provided and click next to continue.

SSRS 19

Next page will show successful configuration of Report Server Database Configuration with all parameters as success

SSRS 20

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.

SSRS 21