This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Install SQL Server Reporting Services
- 4 minutes to read
- 13 contributors
SQL Server Reporting Services installation involves server components for storing report items, rendering reports, and processing of subscription and other report services.
Download SQL Server 2022 Reporting Services from the Microsoft Download Center.
Download SQL Server 2019 Reporting Services from the Microsoft Download Center.
Download SQL Server 2017 Reporting Services from the Microsoft Download Center.
Looking for Power BI Report Server? See Install Power BI Report Server .
Upgrading or migrating from a SQL Server 2016 or earlier version of Reporting Services? See Upgrade and Migrate Reporting Services .
Before you begin
Before you install Reporting Services, review the Hardware and software requirements for installing SQL Server .
Install your report server
Installing a report server is straightforward. There are only a few steps to install the files.
You don't need a SQL Server Database Engine server available at the time of install. You do need one to configure Reporting Services after install.
Find the location of SQLServerReportingServices.exe and launch the installer.
Select Install Reporting Services .
Choose an edition to install and then select Next .
For a free edition, choose either Evaluation or Developer from the drop-down.
Otherwise, enter a product key. Find the product key for SQL Server Reporting Services .
Read and agree to the license terms and conditions and then select Next .
You need to have a Database Engine available to store the report server database. Select Next to install the report server only.
Specify the install location for the report server. Select Install to continue.
The default path is C:\Program Files\Microsoft SQL Server Reporting Services.
After a successful setup, select Configure Report Server to launch the Report Server Configuration Manager.
Configure your report server
After you select Configure Report Server in the setup, you're' presented with Report Server Configuration Manager . For more information, see Report Server Configuration Manager .
You need to create a report server database to complete the initial configuration of Reporting Services. A SQL Server Database server is required to complete this step.
Creating a database on a different server
If you're creating the report server database on a database server on a different machine, you need to change the service account for the report server to a credential that is recognized on the database server.
By default, the report server uses the virtual service account. If you try to create a database on a different server, you may receive the following error on the Applying connection rights step.
System.Data.SqlClient.SqlException (0x80131904): Windows NT user or group '(null)' not found. Check the name again.
To work around the error, you can change the service account to either Network Service or a domain account. Changing the service account to Network Service applies rights in the context of the machine account for the report server.
For more information, see Configure the report server service account .
Windows Service
A Windows service is created as part of the installation. It's displayed as SQL Server Reporting Services . The service name is SQLServerReportingServices .
Default URL reservations
URL reservations are composed of a prefix, host name, port, and virtual directory:
An example of the complete URL string might be as follows:
https://+:80/reportserver , provides access to the report server.
https://+:80/reports , provides access to the web portal.
If you're accessing the report server from a remote machine, you want to make sure you've configured any firewall rules if there's a firewall present.
You need to open up the TCP port that you've configured for your Web Service URL and Web Portal URL. By default, these are configured on TCP port 80.
Additional configuration
To configure integration with the Power BI service so you can pin report items to a Power BI dashboard, see Integrate with the Power BI service .
To configure email for subscriptions processing, see E-Mail settings and E-Mail delivery in a report server .
To configure the web portal so you can access it on a remote computer to view and manage reports, see Configure a firewall for report server access and Configure a report server for remote administration .
Related information
For information on how to install SQL Server Reporting Services native mode, see Install Reporting Services native mode report server .
For information on how to install SQL Server 2016 Reporting Services (and earlier) in SharePoint integration mode, see Install the first Report Server in SharePoint mode .
With your report server installed, begin to create reports and deploy those to your report server. For information on how to start with Report Builder, see Install Report Builder .
To create reports using SQL Server Data Tools, download SQL Server Data Tools .
More questions? Try asking the Reporting Services forum
Additional resources
- SQL Server training
- Write for us!
SQL Server Reporting Service Configuration Manager
After the native installation of the SQL Server Reporting Service, we may need to customize some settings of Report Server. SQL Server Reporting Service provides a tool that is named as such; Report Server Configuration Manager. This tool helps us to customize SQL Server Reporting Service parameters and configurations. With the Report Server Configuration Manager, we can change and customize various parameters of the SQL Server Reporting Service. We can find the below settings in Report Server Configuration Manager:
- Service Account
- Web Service URL
- Web Portal URL
- E-Mail Settings
- Execution Account
- Encryption Keys
- Subscription Settings
- Scale-out Deployment
- Power BI Service (cloud)
We can find and run the Report Server Configuration Manager on the Windows start screen.
- Type Reporting in Windows start screen
Click Report Server Configuration Manager.
In the main tab of configuration manager, we can start and stop Report Server service and at the same time we can find out Report Server edition, product version and other main information about SQL Server Reporting Service.
Service Account: In this tab, we can configure Report Server Windows service account. In the built-in account selection box; we can find Network Service and Virtual Service Accounts . These accounts have minimum privileges which they require to run Report Server and have network login permissions. Microsoft recommends that if we don’t have any domain account we can use a Virtual Service Account. Because this account allows us to avoid password expiration or Report Server breakdowns, but if we have a domain account we can create a dedicated account for Report Server and can customize required security policies to this account and can use this account to run Report Server.
Web Service URL: In this setting tab; we can customize network policies which have access to Report Server web URL. So we can control incoming request to Report Server. In this configuration tab we can configure;
- Can filter the web service request
- Can change web service request ports for HTTP and https in Advanced tab
- Can change virtual directory name for the ReportServer. Default virtual directory name is ReportServer .
- Can bind and configure SSL (Secure Sockets Layer) certification.
Database: The Report Server database stores all report contents, subscriptions and other several data (Dataset, Data source, Roles etc.) which required by Report Server. In this tab, we can configure the Report Server database connection login and password setting. In the default Report Server installation, two databases are created which are named as ReportServer and ReportServerTempDB. At the same time, this tab provides us to change Report Server database.
In Report Server database, we can find a handy view which is named as ExecutionLog2.
This view helps us to find out the usage frequency of reports, execution times and what parameters are used in the reports. By default, this log is kept for 60 days. We can change this setting to connect the SSRS instance with the management studio.
- Open Microsoft SQL Server Management Studio and run as “Administrator”
Select Server type as Reporting Services and click OK
Right click on Report Server instance and select Properties .
Click Advanced tab and change ExecutionLogDaysKept
The other method is;
Click Logging tab and change default number. In this tab execution logging option can disable.
Web Portal URL: In this configuration tab, we can configure web portal virtual directory name and we can change request ports and filter IP address like Web Service URL.
E-Mail Settings: In this configuration tab, we can configure e-mail account for mail subscriptions. Report Server allows us 3 type of authentication methods:
- No authentication
- Username and password for SMTP
- Report server service account NTLM
Now, we will look at how to create an e-mail subscription on SQL Server Reporting Service
- Open report server web portal
Click (…) icon which we want to create mail subscription of report
- Chose to Deliver the report to as E-Mail
- Click Edit schedule and create required subscription schedule
Click Apply
- Click Create Subscription
After completing all these steps about email subscriptions, Report Server will create a job on SQL Agent. If our SQL Agent does not run, we get an error about this.
When we look at the SQL Agent jobs we can find out a job which represents Report Server email subscription.
At the same time, we find some information about this job in Report Server database, the below query returns the following information about subscription.
At last, you can find logs of subscriptions in My Subscription page.
Encryption Keys: In this configuration page, we can find out encryptions keys configurations. Encryption keys are most important for Report Server stored connection strings and other sensitive data in Report Server database and this data is encrypted by these symmetric keys.
For this reason, our first task after the installation of the Report Server should be the backup of this encryption key. Because when we need to move or change the location of the Report Server location. This encryption key provides us to recreate connection strings username and password successfully. If we delete the encryption key Report Server it will clear all connection string usernames and passwords and other sensitive data. We will need to redefine this data.
Backup encryption key
- Click Backup
- Define file location for encryption key
- Set password for encryption key
Subscription Settings: We mentioned about file subscriptions under the email set heading. If we don’t set this setting, the Report Server tries to access file paths with their service account privileges. But in some special security policies service accounts cannot access defined file subscription keys. To handle this issue, we can use file share account. This setting allows us to use different accounts to access file paths.
Scale-out Deployment: In this model, we can run multiple Report Server and can connect one Report Server Database. The benefit of Scale-out Deployment;
- Increase high availability of Report Server
- Handle more concurrent users at the same time without performance issue
- Network load balancing can configure
Conclusions
SQL Server Reporting Services provides us with several configuration settings. With these settings, we can customize the Report Server and adapt it to our business requirements. If you ask my opinion SQL Server Reporting Service is an advanced solution for reporting and business intelligence.
- Configure a Native Mode Report Server Scale – Out Deployment
- Subscription Settings and a File Share Account (Configuration Manager)
- Encryption Keys (SSRS Native Mode)
- Recent Posts
- SQL Cheat Sheet for Newbies - February 21, 2023
- SQL Practice: Common Questions and Answers for the final round interviews - January 26, 2023
- 5 Best Practices for writing SQL queries - December 30, 2022
Related posts:
- Report Subscription Changes in SQL Server Reporting Services 2016
- SQL Server Reporting Service: how to handle common end-user requirements with Report Builder
- Creating Bollinger Bands with SQL Server Reporting Service reports
- Top 10 things you must document in SQL Server Reporting Services (SSRS)
- How to administer SQL Server Reporting Services (SSRS) subscriptions using PowerShell
© 2023 Quest Software Inc. ALL RIGHTS RESERVED. | GDPR | Terms of Use | Privacy
SSRS Install, Setup and Configuration
By: Joe Gavin | Updated: 2020-12-01 | Comments (6) | Related: > Reporting Services Installation
SQL Server Reporting Services (SSRS) is another one of the major components of the Microsoft Business Intelligence (MSBI) stack. It's used to generate interactive and automated reports.
The SSRS installation used to be part of the SQL Server installer up through SQL Server 2016. As of SQL Server 2017, the installation has been moved to its own separate downloadable installer. It is still not overly complicated, but it is helpful to know where to get the installer and what to expect before you go through the installation process. This tip will show you how to obtain the installer and walk through the various screens and options that are part of the installation process for SSRS.
We'll walk through each of the steps of a new installation of SSRS 2019 on Windows Server 2019.
SSRS Minimum Hardware and Software Requirements
You'll likely have a lot more disk and memory than this, but the bare minimum hardware and software required to install SQL Server 2019 are:
- Windows Server 2016 or Windows 10 TH1 1507
- 6 GB of available hard disk space
- 4 GB memory
- 1.4 GHz minimum 64-bit CPU
And to install SSRS, you will need an already installed SQL Server.
SSRS 2019 Install
Obtain and run the ssrs installer.
Download the installer from the Microsoft Download Center here: Microsoft SQL Server 2019 Reporting Services .
Run the SQLServerReportingServices.exe executable when the download is complete, and the first screen will open.
- Click on 'Install Reporting Services'
Product Key
Product key id required for a paid edition.
- Select 'Enter the product key' radio button and enter your product key
License Terms
You will need to agree to the license terms.
- Click 'I accept the license terms' checkbox
Database Server
You will be reminded an installed SQL Server is required to configure the SSRS server and are presented with one option to install Reporting Services.
Install location
This is where you will need to change the SSRS installation directory from the default on the C:\ drive.
- Configure SSRS install directory
Configure Server
At this point Reporting Services is installed and it's time to do some basic configuration to it before we can do anything.
- 'Configure report server' to open the Configuration Manager
Configuration Manager
Reporting Services Configuration Manager program opens, and we will see the machine name and instance will automatically populate. The first step is to connect to the SSRS server.
Service Account
Best practice is to not use the default account to run any of the SQL Server services. This discussion is somewhat out of scope for this tip but Microsoft Docs has more information on configuring Windows service accounts for SQL Server here: Configure Windows Service Accounts and Permissions
- 'Service Account'
- Configure service account
Report Server Databases
The Report Server Database screen is where we create the databases ReportServer and ReportServerTempDB.
- 'Change Database'
SSRS Databases
We are creating a fresh installation of SSRS, so we leave the 'Create a new report server database.' radio button selected. Note: You would just select the 'Choose an existing report server database' button to point Reporting Services to an existing set of databases.
Verify Connectivity to SQL Server
It's a good idea to verify that we can successfully connect to the SQL Server with our credentials here before attempting the database creations.
- 'Test connection'
Continue if Test Connection was successful.
Create Databases
We can now verify our information is correct before proceeding with the database creations.
- Review Summary
Verify Successful Completion
We want to see that each step was successful.
- Verify all steps show Success
Create URLs
Now that we have our databases created it's time to create the SSRS web service. First, we create the Web Service URL.
- 'Web Service URL'
Next, we create the Web Portal URL.
- Web Portal URL
Then SSRS will restart.
Very URL Creation
Time to verify we can connect to both URLs.
- Click 'Web Service URL'
- Click on URL
We expect to see the default browser open to Report Server screen.
Now, we'll check the Web Portal URL.
- 'Web Portal URL'
We expect to see the default browser open to the Reporting Services Screen.
We now have a fully functional SSRS installation that is ready to deploy reports to. Following are some optional settings we can also configure.
- E-mail Settings
If you will have automated report subscriptions going to email, you will need to configure the email settings.
- Enter 'Sender Address' (This doesn't have to be a valid email address on your mail system but it does have to be in the format [email protected] or the SMTP server will reject it.)
- Enter your SMTP server name
- Expand dropdown and choose 'Username and password (Basic)' to enter SMTP credentials if required
- Choose 'Report server service account (NLTM)' to use service account to authenticate
Troubleshooting tip: If you experience any problems getting email working, Microsoft Docs has this very handy guide to troubleshooting SMTP issues using Telnet: Use Telnet to Test SMTP Communication on Exchange Servers . Even though it says Exchange, it's applicable to any SMTP server. It's a little awkward to use at first but a great way to very simply verify you can get through a firewall, and test sender address, etc.
- Subscription Settings
If you are automating reports to go to a file on a file share you can enter the credentials in the Subscription Settings tab.
- Check off 'Specify a file share account'
- Enter Windows account in the form DOMAIN\account
- Enter password
- Confirm password
Close Configuration Manager
- Now that we have a working installation of SSRS, you can find a wealth of further information here: SQL Server Reporting Services Administration Tips
Related Articles
Popular articles.
About the author
Comments For This Article
ReportServer Enterprise Edition
Give ReportServer Enterprise Edition a test run. sales department for a custom quote and further information." data-html="true" title="report server configuration manager 2017 download" data-original-title="License Information">Please note the Terms of Service. The installers and docker images make installation a painless endeavour but also the manual installation is straightforward if you follow the instructions in the Configuration Guide or the best practice installation tutorial . You can test-drive ReportServer Enterprise for 45 days after which it automatically reverts back to the community edition.
Binaries (Manual Installation)
Download the ReportServer binaries. This provides you with the most flexible option to install ReportServer. For installation guidelines see the Configuration Guide as well as the best practice installation tutorial .
Installer Packages
Installer packages for Windows are provided here. The installer includes all of the software necessary to run out of the box (the stack). The process is simple; just download, click next-next-next and you are done! The installer package is completely self contained and will not interfere with other software on your system.
Docker Images
Docker images for the Enterprise Edition can be found at infofabrik/reportserverenterprise in different variants. These variants are partly based on the Docker images created by Bitnami for the Community Edition and are marked by us with the suffix "-b". In addition, it is also possible to obtain a "standalone" version, which lets the reportserver start together with a database in a single container.
ReportServer Community Edition
Binaries and sources (manual installation).
ReportServer Community Edition is available on the ReportServer SourceForge Page and is usable under the AGPL (GNU affero General Public License) . To install ReportServer using the .zip distribution you need to install and configure an application server (e.g. Apache Tomcat ) and a database server (e.g. MySQL , PostgreSQL ).
Additional instructions on how to install ReportServer are given in the ReportServer Config Guide which is also available on SourceForge .
Ready to use installers
Installer packages, docker images, virtual machine images for Windows, Linux and the Mac OS X VM platform are provided through Bitnami .
- Stack Overflow Public questions & answers
- Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers
- Talent Build your employer brand
- Advertising Reach developers & technologists worldwide
- About the company
Collectives™ on Stack Overflow
Find centralized, trusted content and collaborate around the technologies you use most.
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
SQL Server 2017 configuration manager missing reporting services service
This question has been been asked before, but no one has answered it. I installed SQL Server 2017 Express, created a database and installed the Reporting Services (which now is a separate download).
Everything is working, BUT, when I open the SQL Server Configuration Manager, EVERYTHING is there but the SQL Server Reporting Services service.
I have to go to services.msc to start and stop it under the title 'SQL Server Reporting Services'. Did something go wrong with my install? Does the 2017 version of Reporting Services no no longer go in the SQL Server Configuration Manager? Is there something that can be done to get it there or do I have to uninstall and try again?
Thank you in advance!
- reporting-services
- sql-server-2017-express
Nothing went wrong. Because SQL Server Reporting Services is a separate product, it's no longer included in the tools used to manage SQL. While I do not have any documentation for this, I experienced the same thing in SQL 2019.
Your Answer
Sign up or log in, post as a guest.
Required, but never shown
By clicking “Post Your Answer”, you agree to our terms of service , privacy policy and cookie policy
Not the answer you're looking for? Browse other questions tagged reporting-services sql-server-2017-express or ask your own question .
- The Overflow Blog
- The nature of simulating nature: A Q&A with IBM Quantum researcher Dr. Jamie...
- Five Stack Exchange sites turned ten years old this quarter!
- Featured on Meta
- We've added a "Necessary cookies only" option to the cookie consent popup
- Launching the CI/CD and R Collectives and community editing features for...
- The [amazon] tag is being burninated
- Temporary policy: ChatGPT is banned
- Staging Ground Beta 1 Recap, and Reviewers needed for Beta 2
Hot Network Questions
- Does Quantum Computers crack RSA and AES?
- Why did Chandrasekhar use 2.5 for molecular weight in 1931?
- Why are all monasteries human?
- Options for "Cancel this operation?" are "Cancel" and "Yes"; what would be better wording for customers in a hurry?
- Concrete base for parcel box
- Interface goes up/down with LLDP neighbor creation message on a HP Aruba Switch
- Is it inappropriate to tell my boss that "baby talk" is unprofessional?
- Sending a Soyuz ship interplanetary - a plausible option?
- Is it ok to run post hoc comparisons if ANOVA is nearly significant?
- Plotting solutions of a difference equation
- Rolling cube on an infinite chessboard
- Justifying God's existence by our existence
- One-day-ahead prediction of S&P500 with Temporal Convolutional Networks
- Are you saving 'against' an effect if that effect applies when you successfully save?
- Multiple tables with red color curly brackets
- Is it bad that your characters don't have distinct voices or mannerisms?
- The derived category does not satisfy descent - example
- Question regarding pull-up and battery charger charging current
- How to print hardware models for humans
- Earn CC flight miles by paying rent?
- Is there a non-constant function on the sphere that diagonalizes all rotations simultaneously?
- Kolmogorov-Smirnov instability depending on whether values are small or big
- Why do academics stay as adjuncts for years rather than move around?
- Where can I get custom size closet doors, or how do I make one?
Your privacy
By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy .
- An Interview Question
- TECHNOLOGIES
- INTERVIEW PREP
How To Set Up Report Server Configuration Manager For SQL Server Reporting Services (SSRS)
- Satya Karki
- Feb 11, 2021
- Other Artcile
This article describes how to configure SQL server reporting services and setup the environment in detail.
Introduction
Steps to Setup Report Server Configuration Manager
- Report Server Configuration Manager
- SQL Server Reporting Services
Functions in SQL Server: Practical Guide
Featured articles.
IMAGES
VIDEO
COMMENTS
Download Microsoft SQL Server 2017 Reporting Services from Official Microsoft Download Center Internet Explorer was retired on June 15, 2022 IE 11 is no longer accessible. You can reload Internet Explorer sites with IE mode in Microsoft Edge. Get started with Microsoft Edge Microsoft SQL Server 2017 Reporting Services Important!
Select Report Server Configuration Manager. The Reporting Services Configuration Connection dialog box appears so that you can select the report server instance you want to configure. Select Connect. In Server Name, specify the name of the computer on which the report server instance is installed.
Download Microsoft SQL Server 2017 Reporting Services from Official Microsoft Download Center Internet Explorer 11 has retired as of 15 June, 2022 If any site you visit needs Internet Explorer (IE), you can reload it with IE mode in the faster, more modern Microsoft Edge browser. Get started with Microsoft Edge
You do need one to configure Reporting Services after install. Find the location of SQLServerReportingServices.exe and launch the installer. Select Install Reporting Services. Choose an edition to install and then select Next. For a free edition, choose either Evaluation or Developer from the drop-down. Otherwise, enter a product key.
Click Report Server Configuration Manager. In the main tab of configuration manager, we can start and stop Report Server service and at the same time we can find out Report Server edition, product version and other main information about SQL Server Reporting Service.
You first must download the SQL Server Reporting Services install file from https://www.microsoft.com/en-us/download/details.aspx?id=55252. The install process is like just about any other install process you complete; however, at the end of the install, either SSRS can be configured now or at a later time.
Obtain and Run the SSRS Installer. Download the installer from the Microsoft Download Center here: Microsoft SQL Server 2019 Reporting Services. Run the SQLServerReportingServices.exe executable when the download is complete, and the first screen will open. Click on 'Install Reporting Services'.
Download the ReportServer binaries. This provides you with the most flexible option to install ReportServer. For installation guidelines see the Configuration Guide as well as the best practice installation tutorial. Installer Packages Installer packages for Windows are provided here.
The process is simple; just download, click next-next-next and you are done! The installer package is completely self contained and will not interfere with other software on your system. Platform. Version. Windows 64bits. ReportServer 4.5.0-6087 (64bits) Release Notes. Download.
1. This question has been been asked before, but no one has answered it. I installed SQL Server 2017 Express, created a database and installed the Reporting Services (which now is a separate download). Everything is working, BUT, when I open the SQL Server Configuration Manager, EVERYTHING is there but the SQL Server Reporting Services service.
Steps to Setup Report Server Configuration Manager. Click on Connect and insert a Server Name and Select Report Server Instance as shown below, then click on Connect. Then, click on Service Account. Now you have to sign up for a Report Server Service Account. Here, you have two options, use a built-in account, or use another account.
Steps to Setup Report Server Configuration Manager. Click on Connect and insert a Server Name and Select Report Server Instance as shown below, then click on Connect. Then, click on Service Account. Now you have to sign up for a Report Server Service Account. Here, you have two options, use a built-in account, or use another account.
With SQL Server 2017, Reporting Services is decoupled from the SQL Server database engine and install and therefore is no longer managed using SQL Server Configuration Manager. Management of Reporting Services service is done through the Report Server Configuration Manager. You are correct that the Report Server executable path is different ...