How to install SQL Server Reporting Services (SSRS) 2022

A new version of Reporting Services came out last month, read on how to install!

A brand-new version of SSRS was just released, let us install it.

Since 2016, SSRS has come as a separate download from the database. This allows Microsoft the ability to release quicker patches and updates for each product.

Here is the link to download SSRS 2022: https://www.microsoft.com/en-us/download/details.aspx?id=104502

This will bring you to this page. If the download link moved, feel free to Google/Bing it.

Click the download button above. After it downloads find it on your computer and double click it to start the install.

This is the first thing you should see. Click “Install Reporting Services” in the middle of the screen.

Now it will ask you what version you want to install. Since I am on a developer server, I am going to choose Developer.

Now click Next.

I will wait while you read the licensing agreement. When finished, click the box to accept them and press Next.

Install Reporting Services only should already be selected, then press Next.

Now specify the install location for the binaries.

You may or may not get this prompt. Press Yes to start the install.

Now the install will start. This took approximately 7-10 minutes.

When the install is complete, it will want to reboot, so reboot.

When the server is back up, click the Start button and you will have a new entry for Microsoft SQL Server Reporting Services. Open up the Report Server Configuration Manager.

Click Yes to run it.

Now you need to specify the server name that you installed SSRS on and click Connect. Leave the Report Server Instance as SSRS.

Now we just need to work through the options along the left side of the screen. We do not need to setup all of them, but we will setup the important ones today.

Starting with Service Account, decide on a username/account that you want to run the report server service. I am going to stick with the built-in account for now.

Now let’s click the Web Service URL option. Everything looks good. Make sure you press the APPLY button at the bottom. Many times I forget to and wonder why nothing works.

On the Database tab, we now need to pick a server to store our Report Server databases. Click the Change Database button.

Now we need to do some configuration. We are not upgrading so we will select Create a new report server database.

Specify a Server and or instance to create the new database and test your connection. I have a developer instance that I have installed using this tutorial: Installing SQL Server 2022 Developer Edition

Now we need to specify a database name. Since this instance does not have SSRS installed on it, I can use the default name of ReportServer.

I choose Virtual account in a previous step, so I am going to use Service Credentials.

The configuration tool has all of the information it needs to install. Below is summary screen, if you are happy with your choices, press Next. If you want to make any changes, press Previous and make them.

Off it goes installing and configuring.

That did not take long. Press Finish.

The Database tab is now configured.

Almost done!!! Click the Web Portal URL and put a name for the Virtual Directory. I already have a Reports installed, so I am going to choose Reports2. When done click APPLY.

If all has gone well, your screen should look like this.

Now click the URL or copy and paste it into your browser.

You should get to the SSRS home screen. Look Microsoft has changed the theme and we have new colors!

Now I am going to modify a SSRS report and deploy to the new server. I open up the report in Visual Studio and go to the report properties. In the TargetServerURL section, I put in our new server and press OK.

Now we deploy the report, and we get the successful message below.

Refreshing the URL we can see the report and data sources got uploaded.

I click the report and it runs! We have successfully installed and configured SSRS.

Now you can publish your reports. You can also setup subscriptions to automate the running of reports. That takes additional setup which will be covered in a future blog post.

To read more about SQL Server Reporting Services, please visit Microsoft’s official documentation. https://learn.microsoft.com/en-us/sql/reporting-services/what-s-new-in-sql-server-reporting-services-ssrs?view=sql-server-ver16

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s