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.

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

• Video Setup Configure SCCM CB Reporting Services Point
• List of SCCM 2012 Default Reports

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…