How to Configure SSRS 2022 on Windows Server 2025 (Step-by-Step Guide)
Configuring SQL Server Reporting Services (SSRS) 2022 on Windows Server 2025
Hello everyone,
I hope you’re all doing well, and welcome back to SANTECH, your go-to channel for Windows Server and IT infrastructure tutorials.
In this video, we’re going to learn how to configure SQL Server Reporting Services 2022, also known as SSRS, on Windows Server 2025.
SQL Server Reporting Services allows you to create, manage, and deliver reports from SQL Server databases.
This is commonly used by enterprise applications such as Kinetic 2025.2 for reporting and analytics.
By the end of this video, your Reporting Services instance will be fully configured and ready to serve reports.
🧰 Prerequisites
Before we begin, make sure you have the following:
A server running Windows Server 2025
SQL Server 2022 Database Engine already installed
SQL Server Reporting Services 2022 installed
Administrator access on the server
SQL Server Management Studio installed
Network connectivity to the SQL Server instance
In my lab environment, I’m using a Windows Server 2025 machine named KNT2025DBAP01, where SQL Server 2022 and SSRS are already installed.
🖥️ Step 1: Open Reporting Services Configuration Manager
Let’s begin by opening the Reporting Services Configuration Manager.
On the server, open the Start Menu.
Search for Reporting Services Configuration Manager and open it.
When prompted, connect to the local SSRS instance and click Connect.
Once connected, you should see the Reporting Services configuration options on the left-hand side.
⚙️ Step 2: Configure the Service Account
Now let’s configure the Reporting Services service account.
Click on Service Account in the left pane.
Choose the account under which SSRS will run.
In most lab environments, the default virtual account is fine.
In production environments, it’s recommended to use a dedicated domain service account.
Click Apply to save the configuration.
This account will be used by SSRS to access system resources and the report server database.
🔗 Step 3: Configure the Web Service URL
Next, let’s configure the Web Service URL.
Click on Web Service URL.
Leave the default settings or customize the virtual directory name if required.
Click Apply.
Once configured, you’ll see a URL for the SSRS web service.
You can click the link to verify that the web service is accessible.
🗂️ Step 4: Create the Report Server Database
Now we’ll create the Report Server database.
Click on Database in the left pane.
Click Change Database.
Select Create a new report server database and click Next.
Enter the SQL Server instance name and click Test Connection.
Click Next once the connection is successful.
Choose the authentication method and click Next.
Leave the default database name as ReportServer and ReportServerTempDB.
Complete the wizard to create the databases.
Once finished, the Reporting Services databases will be created on SQL Server.
🌐 Step 5: Configure the Web Portal URL
Now let’s configure the Web Portal URL.
Click on Web Portal URL.
Leave the default virtual directory name or customize it if needed.
Click Apply.
After configuration, click the URL to open the SSRS Web Portal in your browser.
This is where you can manage reports, data sources, and folders.
🔐 Optional: Configure HTTPS
In production environments, it’s recommended to secure SSRS using HTTPS.
To configure HTTPS:
Install an SSL certificate on the server
Bind the certificate to the SSRS web service and web portal
Open port 443 on the firewall
We’ll cover HTTPS configuration for SSRS in a separate video.
🔍 Step 6: Verify Reporting Services
Let’s quickly verify that Reporting Services is working correctly.
Open a web browser.
Navigate to the Web Portal URL.
Confirm that the SSRS portal loads successfully.
Log in and verify that you can access the Home page.
At this point, SQL Server Reporting Services 2022 is fully configured and ready for use.
#WindowsServer2025
#SSRS
#SQLServer2022
#ReportingServices
#MicrosoftSQLServer
#BusinessIntelligence
#ServerAdministration
#DBA
#ITTutorial
#TechTutorial
#LearnIT
#DataReporting
#WindowsServer
#ITSupport