kohera-logo-regular.svg

SQL Server Reporting Services 2019: what has changed compared to earlier versions?

When trying to do a standard install of SQL Server, you may have noticed that the 2017 or newer versions of SQL Server Reporting Services (SSRS) aren’t installed as well. That’s because SSRS now has its own separate installer. In this blog, we’ll show some of the changes compared to older versions of the software and detail how to install and update the 2019 version.

1. Installing SQL Server Reporting Services 2019

Let’s first take a look at how you can get SSRS 2019 on your device. In the past you could just install your version of SQL and get the tool with it in one go. However, when installing SQL2019 through the usual method, as you did with edition 2016 or older, you will notice that you can no longer select SQL Server Reporting Services as a feature during your setup.

At the top you see a hyperlink that directs you to the Microsoft download page for the SSRS installer which is now a separate executable. Beware, though, the link included in the 2019 ISO directs you to the 2017 version of Reporting Services. So it is not the correct version.

This is the correct version for 2019. If you’re using the other installer, you will not be able to use the product key you used for the SQL2019 version you installed.

Once you’ve downloaded the correct installer for Reporting Services, copy it to the local server on which you wish to install and double click to start the installation. You will be prompted with the following window:

Click ‘Install Reporting Services’. On the next page, you can choose between a free or a paid edition. The free edition is limited to 180 days, developer and express. For the paid edition, a product key needs to be provided.

This key can be found in the ISO from SQL2019. Run the setup and continue to the product key page.

Once you’ve copied the key, click next. Accept the License terms. Click next and define the install location. Finally, press ‘Install’.

1.1 Changing the name of your Reporting Service

Once the installation is finished, you can start configuring your new Reporting Services.  When you open it, you’ll see that it’s called SSRS. But wait… I always named my reporting service the same as the SQL instance on which it is configured. I also have several tenants with multiple SSRS instances on one host machine. Where is the option to name the service?

Sadly, since 2019 there is no longer an option included in the installation to name the service, and if we start a new installation using the downloaded .exe then we get this:

No option for a second installation or renaming can be found on this installer, unfortunaly.

2. Updating newer versions of SQL Server Reporting Services

Since SSRS is now a stand-alone service, it will not get updated with the patch you apply on your SQL Server, which was the case with version 2016 or older. You’ll find updates for SSRS in the download centre mentioned above. First, verify the version number of your current install by going to properties on the running service.

 

On the download page, you’ll find the version number of the available install files in details section.

Once downloaded and copied to the desired server, just run the file like you would when doing a new install as detailed above.

It’ll look like this:

Select “Upgrade Edition” and just follow the installer.

3. Other points of interest in Reporting Services 2019

As you may have noticed several things are different in the new version of Reporting Services. First, because of the stand-alone installation, the service is no longer visible in the SQL Server configuration manager.

Third, the 2016 version could also be installed using command prompt, but in the official documentation of later versions this is no longer mentioned.

Finally, adding the service account, which normally happens during the installation, now must be done during configuration.

 

 

 

 

 

 

2319-blog-database-specific-security-featured-image
Database specific security in SQL Server
There are many different ways to secure your database. In this blog post we will give most of them a...
kohera-2312-blog-sql-server-level-security-featured-image
SQL Server security on server level
In this blog, we’re going to look at the options we have for server level security. In SQL Server we...
blog-security_1
Microsoft SQL Server history
Since its inception in 1989, Microsoft SQL Server is a critical component of many organizations' data infrastructure. As data has...
DSC_1388
Aggregaties
Power BI Desktop is een prachtige tool om snel data-analyses te kunnen uitvoeren. Je connecteert op een databron, importeert en...
dba image
DBA is not that scary
Often when talking to people who are looking for a career path in the data world I feel like there...
blog-2303
How do you link an SCD Type 2 table in Power Query?
This article uses a simple example to demonstrate how to link an SCD Type 2 table in Power Query to...