Fix SCCM Report Server cannot Open a Connection Error ConfigMgr | Endpoint Manager | Configuration Manager
Let’s see how to fix SCCM Report Server cannot Open a Connection to the Report Server Database Error. Configuration Manager has rich capabilities to collect lots of information from endpoints. Once collected this information is stored in the ConfigMgr SQL DB and retrieved through SSRS reports.
You can refer to the video tutorial about Reporting Services point from here . I have a previous blog post that has the list of default SCCM 2012 reports “ List of SCCM 2012 Default 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 .
The SSRS report was giving the following error “ The report server cannot open a connection to the report server database “.
http://sqlmemcm/Reports/Pages/Folder.aspx
FIX SSRS Reporting Issue
Let’s check now how to fix this issue name or password is incorrect. I’m trying to check the DB connectivity using the following tool. Also, don’t miss the notes section below.
- Launch SQL Server Reporting Services Configuration Manager from the start menu
- Click on the Find button to check the available servers and Report server instances
- Click on the Connect button to continue.
- Make sure the SQL reporting service is running .
NOTE! – Report Server Web Service is not configured. Default values have been provided to you. To access these defaults simply press the APPLY button , or else change them and then press Apply .
- Wait to complete the configuration of the web service URL for the SSRS reporting service.
- Now the configuration is completed.
- Click on the Exit button.
- Click on Database
- Click on Change Credentials
NOTE! – Because it was giving the wrong user name or password error, you need to click on change credentials and enter the correct user name and password.
- Click on Test Connection
- Click on the Next button
- Enter the user name and password
- Click the Next button.
- Click the Next button to continue.
- Click on the Finish button.
NOTE! – This wizard won’t check the user name and password whether it’s incorrect or not. So be careful.
- Click on t he Exit button.
After changing the user name and password, you might get a different error if you have not configured the reporting service point role. You need to make sure that you configure A reporting services point from the Configuration Manager console.
- Video Setup Configure SCCM CB Reporting Services Point
- List of SCCM 2012 Default Reports
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 blogger, Speaker, and Local User Group HTMD Community leader. His main focus is on Device Management technologies like SCCM 2012, Current Branch, and Intune. E writes about ConfigMgr, Windows 11, Windows 10, Azure AD, Microsoft Intune, Windows 365, AVD, etc…
1 thought on “Fix SCCM Report Server cannot Open a Connection Error ConfigMgr | Endpoint Manager | Configuration Manager”
I have upgraded SCCM database from 2008R2 to 2016SP1. SSRS also upgraded to 2016. Report Server is working fine.Reports are running but unable to detect SSRS in SCCM. Any specific reason?
Leave a Comment Cancel reply
This site uses Akismet to reduce spam. Learn how your comment data is processed .
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Reporting stops working after you move a reporting services point or enable TLS 1.2 in Configuration Manager
- 2 minutes to read
- 2 contributors
This article helps you fix an issue in which Configuration Manager reporting doesn't work after you move the reporting services point role to a new server or you enable TLS 1.2 on the site servers.
Original product version: Configuration Manager (current branch) Original KB number: 4503578
After you move the reporting services point role to a new server, or you enable TLS 1.2 on the site servers, reporting no longer works in Configuration Manager.
The following error messages are logged in the Srsrp.log file on the reporting services point:
Successfully created srsserver SMS_SRS_REPORTING_POINT Reporting Services URL from Registry [https://<ServerName>.contoso.com/SCCMReportServer/ReportService2005.asmx] SMS_SRS_REPORTING_POINT The underlying connection was closed: An unexpected error occurred on a receive. SMS_SRS_REPORTING_POINT (!) SRS not detected as running SMS_SRS_REPORTING_POINT Failures reported during periodic health check by the SRS Server [<ServerName>.contoso.com]. SMS_SRS_REPORTING_POINT
This issue occurs because the site servers and site systems don't meet the requirements that are described in How to enable TLS 1.2 .
To fix this issue and enable TLS 1.2 in Configuration Manager, make sure that the site servers and site systems meet the requirements that are described in How to enable TLS 1.2 .
To do this, follow these steps:
Verify that .NET Framework is updated and has strong cryptography enabled on all relevant computers.
To do this, first determine your .NET Framework version number, and then follow these guidelines:
.NET Framework 4.6.2 supports TLS 1.1 and TLS 1.2. No additional changes are required.
.NET Framework 4.6 and earlier versions must be updated to support TLS 1.1 and TLS 1.2.
If you're using .NET Framework 4.5.1 or 4.5.2 on Windows 8.1, Windows RT 8.1, or Windows Server 2012, the relevant updates and details are also available from Microsoft Update Catalog .
All Configuration Manager client computers and site systems should have the following registry values set.
For 32-bit applications that are running on 32-bit systems or 64-bit applications that are running on 64-bit systems:
For 32-bit applications that are running on 64-bit systems:
Verify that the SMS_Executive service is restarted after any updates are installed.
Was this page helpful?
Additional resources
SCCM Reporting Not Working
The reports in SCCM are not working at all. I went into \Monitoring\Overview\Reporting\Reports and it shows no items found. If I browse to the reports URL on the server it shows 503, service unavailable. Is there supposed to be a site in IIS, because I do not see one. I am wondering if it somehow was deleted. Any ideas?
EDIT: We were able to resolve this. We completely removed the Reporting Services role as well as Reporting Services in SQL. Then rebuilt everything. We followed the article https://www.prajwaldesai.com/how-to-re-install-sql-reporting-services-for-sccm/#:~:text=Uninstall%20SQL%20Reporting%20services%20%E2%80%93%20On,the%20Uninstall%20or%20Change%20option .
Check your Report Services Component Status I'm betting it's Red with Critical
Here is an easy solution just run a reset on the service it will fix it most of the time; You can also look into the logs and see what it is. Check the Component Reset it or Clear the logs it works for me 99% of the time. Also if need be a server reset can fix it if the logs doesn't show what the issue is
You're right.. the logs show just 10 minutes ago "the report server service is not running on Reporting Service Point". I checked services.msc but I do not see a report server service. I do see a SQL Reporting Services, and that is running.
Am I supposed to see a Report Server service?
if you have not used ssrs in a while it will autoshutdown. try restarting the service.
the logs show just 10 minutes ago "the report server service is not running on Reporting Service Point". I checked services.msc but I do not see a report server service. I do see a SQL Reporting Services, and that is running.
Log into your server and restart the service
About Community
Prajwal Desai
How to Install SCCM Reporting Services Point | ConfigMgr SSRS
This article is a step-by-step guide to install SCCM reporting services point role. I will show you how to install and configure the ConfigMgr SSRS reporting services point and enable reports.
To access reports in Configuration Manager, you need a reporting services point. When you run the reports in ConfigMgr, the Reporting Services connects to the Configuration Manager site database to retrieve data that is returned when you run reports.
If you are thinking of how do I enable reporting in SCCM, it involves a series of steps before you can use the reports in Configuration Manager. This guide shows every step that you require to install and configure reports in SCCM.
Like SCCM log files , there are many reports that come preinstalled with ConfigMgr. Configuration Manager supplies 470+ built-in reports, covering many of the reporting tasks that you might want to do. You can also use the SQL statements in these reports to help you write your own reports.
If you are looking to repair SSRS or reinstall the reporting services point, refer to the following guide on SCCM reinstall reporting services point .
What is Reporting in SCCM?
Reporting in Microsoft Endpoint Configuration Manager provides a set of tools and resources that help you use the advanced reporting capabilities of SQL Server Reporting Services. SCCM Reporting helps you gather, organize, and present information about users, hardware and software inventory, software updates, applications, site status, and other Configuration Manager operations in your organization.
Reporting provides you with a number of predefined reports that you can use as is or modify to meet your needs, as well as the ability to create custom reports. Configuration Manager includes over 450 report definitions in over 50 report folders, which are copied to the root report folder in SQL Server Reporting Services during the reporting services point installation process.
The reports are organized in subfolders based on the report category and displayed in the Configuration Manager console. Reports are not propagated up or down the Configuration Manager hierarchy; they run only against the database of the site in which they are created.
You can run the reports in Configuration Manager console by using Report Viewer , or you can run reports from a browser by using Report Manager. To run reports in the Configuration Manager console, you must have the Read right for the Site permission and the permissions configured for specific objects. The user account will need Modify right for the Site permission to modify the reports.
What is Reporting Services Point in SCCM?
SCCM’s reporting services point connects with SSRS in order to copy SCCM reports to a defined report folder. SCCM will establish the general and security settings for the reporting service. When you run reports, Reporting Services connects to the SCCM site DB to retrieve the returned data.
A Reporting Services Point role can be installed on a central administration site, primary sites, and on multiple site systems at a site and at other sites in the hierarchy. The reporting services point is not supported on Configuration Manager secondary sites .
By definition, the reporting services point is a site system role that is installed on a server that is running Microsoft SQL Server Reporting Services. The reporting services point performs the following tasks:
- Reporting Services receives a copy of the Configuration Manager report definitions.
- Report folders are created depending on report categories.
- Configures the security policy for report folders and reports. These policies are based on Configuration Manager administrative users’ role-based rights. If you alter the security policy, the reporting services point connects to Reporting Services every 10 minutes to reapply it.
Prerequisites for Reporting Services Point
When you plan to install the reporting services point role in SCCM, the following prerequisites are required.
- .NET Framework for the Reporting Services Point. Use .NET Framework 4.8 and above.
- SQL Server Reporting Services for RSP
- SQL Server Native Client for the Reporting Services Point
- SQL Server 2017, SQL Server 2022 or later.
SQL Server Installation for Configuration Manager
One of the prerequisites for installing the Configuration Manager is SQL Server. The Configuration Manager stores its entire data in a dedicated database on SQL server. Each Microsoft Endpoint Configuration Manager site requires a supported SQL Server version and configuration to host the site database. Hence, you must install the supported SQL Server version for Configuration Manager .
The latest versions of Configuration Manager current branch support SQL Server 2017, SQL Server 2019 and later. You can install any of these versions of SQL Server for Configuration Manager. This guide assumes that you have already installed SQL Server for ConfigMgr. If you are planning to install the SQL Server for SCCM, refer to the following guides:
- Install SQL Server 2017 for Configuration Manager
- Install SQL Server 2019 for SCCM | ConfigMgr
- Upgrade SQL Server 2014 to SQL Server 2017
Create SSRS Connection Account
When you install SCCM reporting services point, you use a dedicated account which is nothing but the SSRS connection account. When you create this account in AD, provide it NO further domain access. Please do not make it a domain administrator. All it requires are regular, low rights. Make it a local administrator on SQL Server or the SSRS server at all costs. SCCM handles granting the rights required by SQL Server and SSRS.
Download SQL Server Reporting Services for SCCM
You can download the latest version of SQL Server Reporting Services from the Microsoft Download center . Older versions of SQL Server would install the SQL server and the reporting services. However, with SQL Server version 2017 and later, you must download the SSRS installer separately and install it.
Install SQL Server Reporting Services (SSRS)
SQL Server Reporting Services is a server-based reporting platform that provides comprehensive reporting functionality. Reporting Services offers the following features:
- Paginated reports optimized for document generation and printing.
- Mobile reports optimized for mobile devices, with responsive layout that adapts to different devices and the different ways you hold them.
- A modern web portal you can view in any modern web browser.
To install SSRS for SCCM, you will require the .NET Framework 4.7 or later and SQL Server Database Engine (2012 SP4 or later) , to store the report server database.
In this example, I will be installing SQL Server 2019 Reporting Services for Configuration Manager. Run the SQLServerReportingServices.msi installer to start the installation.
On the Choose an edition to install scree, there are two options:
- Choose a free edition – Evaluation (180 days), Developer, Express.
- Enter the product key.
Select the second option and enter the product key for SQL Server Reporting Services.
Tip : When you install the SQL server for Configuration Manager, the product key is displayed on one of the initial setup screens. You must use the same key while installing the SSRS.
Click Next .
Click I accept the license terms and then click Next .
As mentioned earlier, you’ll need an instance of SQL Server Database engine to store the report server database. This option was enabled during the SQL Server installation. Select Install Reporting Services only and click Next .
I am going to leave the install location to default, click Install . This begins the installation of Reporting Services. In the next section, we will look at the steps to configure the reporting services.
To launch the SQL Server Reporting Services, click Start and type “ Report Server “. From the list of search results, click “ Report Server Configuration Manager.”
Configure Reporting Server Configuration Manager
In this step, we will configure the reporting services for Configuration Manager. In the completion window of SQL Server 2019 Reporting Services, select Configure manually and customize settings and click Configure Report Server .
In the Report Server Configuration Manager window, select the report server instance as SSRS and click Connect .
Select the Database tab and here we see the current report server database is empty. This means there is a report server database that has been created before. To create a new report server database for SCCM, select Change Database .
On the Action window, select Create a new report server database . Click Next .
Test the credentials that you use to connect to the database server. If you see “ Test connection succeeded “, it means the credentials are valid, and you can proceed.
On the Database page of the Report Server Database configuration wizard, choose the Database Name , which is by default set as ReportServer . Select the database language, for example, English (United States) . The report server mode is set to native, which works fine for Configuration Manager. Click Next .
Specify the credentials of an existing account that the report server will use to connect to the report server database. Permission to access the report server database will be automatically granted to the account you specify. Select the Authentication type as Windows Credentials and specify the account name and password. Click Next .
This begins the report server database creation now, and on the Progress and Finish page, ensure all the steps show as Success . Click Finish to close the report server database configuration wizard.
On the Database tab, we see the tasks have been completed successfully. If you don’t see them, you can click on the “ Apply ” button.
Configure the Web Service URL and Web Portal URL
In this step, we will configure a URL that is used to access the Report Server. You can define multiple URLs for a single report server instance and even specify additional parameters on the URL.
In the Report Server Configuration Manager tool, select the Web Server URL tab, and at the bottom, click the Apply button. This will configure the web service URL for reports.
Similarly, click the Web portal URL and click Apply . This will configure a dedicated URL to access the web portal. Click the Exit button to close the report server configuration manager wizard.
On the Web Service URL page , click the URL in Report Service Web Service URLs to test the connection to the report folder. The Windows Security dialog box might open and prompt you for security credentials. By default, your user account is displayed. Enter your password and click OK . Verify that the webpage opens successfully. Close the browser window.
At this point, no Configuration Manager reports are visible because we are yet to install SCCM reporting services point role. Once you install the reporting services point role, the reports will be visible in Configuration Manager console and web URL.
Install SCCM Reporting Services Point Role | ConfigMgr
Follow the below steps to install a new reporting services point role using SCCM console:
- Launch the SCCM console.
- Click Administration > Site Configuration . Right click Servers and Site System Roles .
- Right-click SQL Server on which you plan to install reporting services point role and select Add Site System Roles .
On the General window of Add Site System Roles wizard , you have two options for specifying the site system installation account.
- Use the site servers computer account to install this site system : Select this option to install the site system if both the site server and site system servers are in the same domain. Furthermore, the site server account should be added to the local administrators group on the remote site system server.
- Use another account for installing this site system : Use this option if the site server and site system servers are in a different domain and there is no two-way trust.
Typically, the first option is preferred in most cases while deploying the reporting services point role in an organization. Verify the Active Directory Forest and Active Directory Domain names and click Next .
If your organization uses Internet Proxy server, specify it on the Proxy page otherwise click Next .
On the System Role Selection page, from the list of roles, select Reporting Services Point and click Next .
On the Reporting Services point page, you configure the settings for Reporting Services. This step is critical because the majority of errors such as reporting services server instance blank, is observed here.
If you have installed and configured the reporting services correctly and if the report server database is successfully created, this step should be easy for you. Ideally, the Reporting Services server instance should be automatically populated to SSRS. If the reporting services server instance is blank, you might need to verify the account permissions and perform additional troubleshooting steps .
In the below example, we see the Site Database server name, Database name, Folder Name, and Reporting services server instance are automatically populated.
Specify the credentials that SQL Reporting Services will use when connecting to the Configuration Manager site database and click on Verify . The pop-up window “ Successfully Verified ” confirms the reporting services point account permissions are correct. Click Next .
Review the reporting services point role configuration on Summary page and click Next . On the Completion window, click Close . This completes the reporting services point sccm installation steps.
SCCM Reporting Services Point Log Files
When you install a new reporting services point for SCCM, you can use the following log files to troubleshoot the SSRS installation errors. The log files are located in C:\Program Files\Microsoft Configuration Manager\Logs .
The following table lists the Configuration Manager log files that contain information related to reporting services point in SCCM.
Take a look at the full list of all the important Configuration Manager log files and their locations .
Verify Reporting Services Point Role Installation
To verify that the Reporting Services point role has been installed, launch the SCCM console, click on Monitoring , expand System Sta tus , select Component Status, and look for SMS_SRS_REPORTING_POINT .
From the below screenshot, we see the SMS_SRS_REPORTING_POINT component is online. The green icon indicates the reporting point is healthy and there are no errors.
Let’s review the log file named srsrp.log and find out . The log file srsrp.log is located on the site server in the following path: C:\Program Files\Microsoft Configuration Manager\Logs .
The below two lines from the srsrp.log file confirm the successful installation of ConfigMgr SSRS reporting services point.
In the srsrp.log file, we see the Configuration Manager reports are deployed successfully. Each of these reports are created in a separate folder. Learn how to add SCCM Reports as favorites .
In the srsrpsetup.log , we see the ConfigMgr SSRS role installation was successful.
Please let us know if you found this article to be useful in the comments section below. Gratitude for reading!
Prajwal Desai is a Microsoft MVP in Enterprise Mobility. He writes articles on SCCM, Intune, Configuration Manager, Microsoft Intune, Azure, Windows Server, Windows 11, WordPress and other topics, with the goal of providing people with useful information.
Thanks for the post, a nice walkthrough.
Hi Prajwal,
I installed report services on my sccm server, and it works as usual except that the report account start to register Audit Failure log (4625) ASAP I added the service to SCCM, and every time i open SCCM console. I’m using WS2022, SQL 2019, SSRS 2019. I have few environment which has the same configuration, and there are no problem at all. Do you have any idea?
Leave a Reply Cancel reply
Your email address will not be published. Required fields are marked *
Save my name, email, and website in this browser for the next time I comment.
IMAGES
VIDEO
COMMENTS
SCCM Troubleshooting Tips on Reporting Server SSRS Issues ConfigMgr Endpoint Manager · 1. Check SQL server reporting services. · 2. Check the
After changing the user name and password, you might get a different error if you have not configured the reporting service point role. You need
The SQL Server runs on its own Windows Server. CU9 is installed. SCCM is communicating with SQL server and all components status is okay, but when installing
Resolution · Verify that .NET Framework is updated and has strong cryptography enabled on all relevant computers. To do this, first determine
b. If this is not working, the real issue should be displayed in an error message. If not, enable report errors and retry the
The tool is called Reporting Services Configuration Manger, if everything is greyed out then there is a problem with SSRS and you need to dig
However there is a configuration setting that can be tweaked to get around this problem but it is not recommended to tweak this setting if the
The reporting services point is not supported on Configuration ... on a server that is running Microsoft SQL Server Reporting Services.
If the Reporting Services page still does not appear, log in to the operating system with the Administrator account and run the Internet Explorer web browser as
Open SQL Server Management Studio · Delete ReportServer and ReportServerTemp · Open Reporting Services Configuration Manager · Select Database · Re-create the