ConfigMgr Create a New Database for SSRS Reporting Service | SCCM | Configuration Manager | Endpoint Manager

Let’s have a quick look at the step-by-step guide to create a new database for SSRS reporting service. This activity could help to troubleshoot some of the SSRS issues. The SQL Server Reporting Services (SSRS) provides a set of on-premises tools and services that create, deploy, and manage mobile and paginated reports.

You can refer to SQL installation and SQL reporting service role installation details from the previous blog posts. 1. SQL Server – Installation 2. SQL Server Database Migration.

Create a New Database for SSRS Reporting Service

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

Patch My PC
  • Launch SQL Server Reporting Services Configuration Manager from the start menu
SQL server Reporting Services Configuration Manager - ConfigMgr Create a New Database for SSRS Reporting Service
ConfigMgr Create a New Database for SSRS Reporting Service
  • Select the Database option.
  • Click on the Change Database button.
ConfigMgr Create a New Database for SSRS Reporting Service
ConfigMgr Create a New Database for SSRS Reporting Service
  • 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.
1E Nomad
Advertisement
ConfigMgr Create a New Database for SSRS Reporting Service
ConfigMgr Create a New Database for SSRS Reporting Service

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

  • Click on the Test Connection button to check whether the tool is able to connect to the database or not.
  • 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
  • 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
ConfigMgr Create a New Database for SSRS Reporting Service
  • Enter the credentials.
  • Click on the Next button.
ConfigMgr Create a New Database for SSRS Reporting Service
  • Click on the Next button from the summary page.
ConfigMgr Create a New Database for SSRS Reporting Service
ConfigMgr Create a New Database for SSRS Reporting Service
  • Wait for the configuration to get completed. In the backend, this configures the database for SSRS reports.
ConfigMgr Create a New Database for SSRS Reporting Service
  • Click on Finish to complete the process for the creation of a new SSRS reporting server database.
ConfigMgr Create a New Database for SSRS Reporting Service
ConfigMgr Create a New Database for SSRS Reporting Service
  • Click on the Exit button.
ConfigMgr Create a New Database for SSRS Reporting Service

Results

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

ConfigMgr Create a New Database for SSRS Reporting Service | SCCM | Configuration Manager | Endpoint Manager 1
  • Check the reports from the URL -> http://sqlmemcm/ReportServer
ConfigMgr Create a New Database for SSRS Reporting Service | SCCM | Configuration Manager | Endpoint Manager 2
  • 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 | Configuration Manager | Endpoint Manager 3

Resources

Author

Anoop is Microsoft MVP! He is a Solution Architect in enterprise client management with more than 20 years of experience (calculation done in 2021) in IT. He is a logger, Speaker, and Local User Group HTMD Community leader. His main focus is on 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…

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.