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.
Issue
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
The report server cannot open a connection to the report server database. The log on failed. (rsReportServerDatabaseLogonFailed) Get Online Help The report server cannot open a connection to the report server database. The log on failed. (rsInternalError) Get Online Help The user name or password is incorrect. (Exception from HRESULT: 0x8007052E)
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 the Exit button.
Results
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.
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 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…
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?