ConfigMgr Create a New Database for SSRS Reporting Service SCCM

Today, I will discuss ConfigMgr Create a New Database for SSRS Reporting Service SCCM. Let’s have a quick look at the step-by-step guide to creating a new database for the SSRS reporting service.

This activity could help troubleshoot some of the SSRS issues.

SQL Server Reporting Services (SSRS) provides a set of on-premises tools and services for creating, deploying, and managing mobile and paginated reports.

The details of the SQL installation and SQL reporting service role installation are in the previous blog posts: 1. SQL Server—Installation 2. SQL Server Database Migration.

Create a New Database for the SSRS Reporting Service

Let’s follow the steps to create a new database for the SSRS reporting service.

Launch SQL Server Reporting Services Configuration Manager from the start menu

ConfigMgr Create a New Database for SSRS Reporting Service SCCM - Fig.1 — ConfigMgr Create a New Database for SSRS Reporting Service SCCM – Fig.1

Select the Database option.

Click on the Change Database button.

ConfigMgr Create a New Database for SSRS Reporting Service SCCM - Fig.2 — ConfigMgr Create a New Database for SSRS Reporting Service SCCM – Fig.2

Report Server Database Configuration Wizard.
- Select a task from the following list.
  - Select the option called Create a new report server database to create a new SSRS reporting service database.
- Click on the Next button to continue.

ConfigMgr Create a New Database for SSRS Reporting Service SCCM - Fig.3 — ConfigMgr Create a New Database for SSRS Reporting Service SCCM – Fig.3

It populates the SQL server name and authentication type details. So you don’t need to change anything.

Click the Test Connection button to check whether the tool can connect to the database.
Click OK on the popup windows where it showed as Test connection succeeded.
Click on the Next button to continue.

ConfigMgr Create a New Database for SSRS Reporting Service SCCM - Fig.4 — ConfigMgr Create a New Database for SSRS Reporting Service SCCM – Fig.4

All the following details are automatically populated.
- Database Name – ReportServer
- Time Database Name – ReportServerTemp
- Language – English (United States)
- Report Server Mode – Native
Click on the Next to continue.

ConfigMgr Create a New Database for SSRS Reporting Service SCCM - Fig.5 — ConfigMgr Create a New Database for SSRS Reporting Service SCCM – Fig.5

Enter the credentials.

Click on the Next button.

ConfigMgr Create a New Database for SSRS Reporting Service SCCM - Fig.6 — ConfigMgr Create a New Database for SSRS Reporting Service SCCM – Fig.6

Click on the Next button from the summary page.

ConfigMgr Create a New Database for SSRS Reporting Service SCCM - Fig.7 — ConfigMgr Create a New Database for SSRS Reporting Service SCCM – Fig.7

Wait for the configuration to be completed. In the backend, this configures the database for SSRS reports.

ConfigMgr Create a New Database for SSRS Reporting Service SCCM - Fig.8 — ConfigMgr Create a New Database for SSRS Reporting Service SCCM – Fig.8

Click on Finish to complete the creation of a new SSRS reporting server database.

ConfigMgr Create a New Database for SSRS Reporting Service SCCM - Fig.9 — ConfigMgr Create a New Database for SSRS Reporting Service SCCM – Fig.9

Click on the Exit button.

ConfigMgr Create a New Database for SSRS Reporting Service SCCM - Fig.10 — ConfigMgr Create a New Database for SSRS Reporting Service SCCM – Fig.10

Results

As you can see, the report server database was created in SQL.

ConfigMgr Create a New Database for SSRS Reporting Service SCCM - Fig.11 — ConfigMgr Create a New Database for SSRS Reporting Service SCCM – Fig.11

Check the reports from the URL -> http://sqlmemcm/ReportServer

ConfigMgr Create a New Database for SSRS Reporting Service SCCM - Fig.12 — ConfigMgr Create a New Database for SSRS Reporting Service SCCM – Fig.12

After setting up the ConfigMgr SSRS Reporting Services Point, you can view SCCM SSRS reports

ConfigMgr Create a New Database for SSRS Reporting Service SCCM - Fig.13 — ConfigMgr Create a New Database for SSRS Reporting Service SCCM – Fig.13

Resources

We are on WhatsApp. To get the latest step-by-step guides and news updates, Join our Channel. Click here –HTMD WhatsApp.

Author

Anoop C Nair is Microsoft MVP! He is a Device Management Admin with more than 20 years of experience (calculation done in 2021) in IT. He is a Blogger, Speaker, and Local User Group HTMD Community leader. His primary focus is Device Management technologies like SCCM 2012, Current Branch, and Intune. He writes about ConfigMgr, Windows 11, Windows 10, Azure AD, Microsoft Intune, Windows 365, AVD, etc.

Written by

Anoop C Nair

Anoop C Nair is Workplace Technology solution architect with 25+ years of experience in global enterprise organizations such as JP Morgan, Capgemini, etc. Microsoft Certified Trainer. Microsoft MVP from 2015 onwards for consecutive 11+ years! He also conducts Intune and modern workplace tech training for enterprise organizations. He is Blogger, Speaker, and Founder of HTMD Community and HTMD Conference. His main focus is on Device Management technologies like Intune, Windows, Cloud PC. He writes about technologies like Intune, SCCM, Windows, Cloud PC, Windows, Entra, Microsoft Security.

View all posts

Sign up to get the best of How To Manage Devices straight to your inbox!

Table of Contents

Create a New Database for the SSRS Reporting Service

Results

Resources

Author

Discussion

Join the discussion Cancel reply

Related guides

Windows 11 KB5101650 KB5099414 July 2026 Patch and 3 Zero Day Vulnerabilities and 570 Flaws

2026 June KB5094126 KB5093998 Windows 11 Patch | 3 Zero Day Vulnerabilities and 200 Flaws

2026 May KB5089549 KB5087420 Windows 11 Patch | 0 Zero Day Vulnerabilities and 120 Flaws

ConfigMgr 2603 Introduces New Early Update Enrollment Process