SQL Server 2016: Install and Configure SSRS
Introduction
In this article, we will show how to Install and Configure SQL Server Reporting Service 2016 (SSRS) Step by Step.
https://gallery.technet.microsoft.com/site/view/file/182895/1/SSRS%202016.png
Note
You might also like to read Install and configure Power BI Report Server step by step
Prerequisites
Before we getting started, you should make sure and do the following:
- You have the same SQL Server version installation media that was used when the SQL Server is being installed.
- Create a new service account for Reporting Service. (Microsoft recommends to specify and use a separate account for each SQL Server service)
- Specify the authentication type and the account that have permission to connect to the database server. (Will be used during configuring the Report Server DB)
- Specify the authentication type and the account that the report server will use to connect to the report server database. (Will be used during configuring the Report Server DB)
Steps
Install SQL Server Reporting Service 2016 (SSRS)
Mount the SQL Server installation Media ISO/CD > Run the SQL Server Installation file.
In SQL Server Installation Center > click Installation.
Click New SQL Server stand-alone installation or add features to an existing installation.
In "Global Rules", wait for checking the problem that might occur when installing SQL Server setup files. Failure must be corrected to continue.
In "Microsoft Update", it's recommended to check the Microsoft update for security and important updates but at the end, it's up to you to check it or not.
In "Install Setup files", if an update for SQL Server setup is found and specified to be included the updated will be installed.
In "Install Rules", wait for checking the potential problems that might occur while running setup. Failure must be corrected to continue.
In "Installation type", specify add features to an existing instance of SQL Server 2016.
In "Feature Selection", check Reporting Service - Native.
In "Server Configuration", specify a separate Service account for Reporting Service (Above-mentioned in Prerequisites).
In "Reporting Service Configuration", specify the "Install only" configuration mode.
Finally, click Next to run the setup.
Wait till the installation is completed successfully.
Configure SQL Server Reporting Service 2016 (SSRS).
Once the SSRS feature is installed successfully, you should configure it manually by doing the following:
Open Reporting Service Configuration Manager.
Connect to the Report Server Instance.
https://gallery.technet.microsoft.com/site/view/file/182982/1/Connect%20to%20SSRS%202016.png
Review Report Server Status and make sure it's started.
In "Service Account", you will find the report server service account that runs the Report Server Service.
https://gallery.technet.microsoft.com/site/view/file/182985/1/SRS%202016%20Service%20Account.png
Go first to the "Database" section to configure the database that holds the all report server content and application data.
https://gallery.technet.microsoft.com/site/view/file/182986/1/Change%20Database%20SSRS2016.png
Note: in case you have deleted a report in reporting service, you can't restore it! the available options are
- you have a copy of the deleted report on your local machine so you can upload it again.
- you have a backup from the report database so you can restore it.
Click Change database to create the report server database for the first time.
Check Create a new report server database.
Make sure the database server is correct.
Set the authentication type as (Integrated User or SQL Server account).
Note: this account must have permission to connect to the database server.
Provide the correct account credentials.
Test the connection and make sure that the connection is established successfully.
Specify the database name as you prefer.
Specify the credentials of an existing account that the report server will use to connect to the report server database.
Review the summary information, and make sure that everything is set properly before proceeding.
Wait while the report server database wizard configures the database then click Finish.
Go back to configure the "Report Server Web Service URL".
- Set the Report Server Web Service URL virtual directory.
- Set the Report Server web service site identifications based on your requirements then click Apply.
Test the Report Server Web Service URL that should be now browsed properly.
Go now to the "Report Manager URL", specify the virtual directory as you prefer then click Apply to configure it.
Once the Report Manager Completed Successfully, Click the Report Manager URL to test it.
Great, it should be now browsed properly.
Note
If you got a permission issue to access report manager, please check SSRS 2016: You are not allowed to view this folder. Contact your administrator to obtain the necessary permissions.
Go now to the "Encryption keys".
https://gallery.technet.microsoft.com/site/view/file/182999/1/Encryption%20Keys%20SSRS%202016.png
Take a backup of the symmetric key that used to encrypt sensitive data in the report server database like connection strings, credentials ...etc. it will be helpful in case you migrate or move the report server installation to another server, you can restore this key to regain access to the encrypted content.
Now the SSRS 2016 is installed and configured properly, but you will not able to create a new reports using report manger till download and install the Report Builder.
Download The Report Builder 2016
Open the Microsoft® SQL Server® 2016 Report Builder.
Select your preferred language, then click Download.
Install the Report Builder 2016
Double-click the downloaded file "ReportBuilder3".
- Click Next, then "I accept the terms in licencing agreement".
- Optionally, specify the default target server URL that is the "Report Manager URL".
- Click Install.
Create the first report in Reporting Service 2016
Open Report Manager URL.
Add a paginated report.
Allow the report builder to open. "remove always ask before opening this type of address" option.
Wait a moment for opening the report builder.
As you like, select the type of report.
Start now building your first report in SSRS 2016.
