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 all 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“.

Patch My PC

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 SCCM Report Server cannot Open
Fix Report Server cannot Open a Connection Error ConfigMgr | SCCM Fix SCCM Report Server cannot Open

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
Fix SCCM Report Server cannot Open | ConfigMgr
Fix SCCM Report Server cannot Open | ConfigMgr
  • Click on the Find button to check the available servers and Report server instances
  • Click on the Connect button to continue.
Fix Report Server cannot Open a Connection Error ConfigMgr | SCCM
Fix SCCM Report Server cannot Open | ConfigMgr
  • Make sure the SQL reporting service is running.
Fix Report Server cannot Open a Connection Error ConfigMgr | SCCM
Fix SCCM Report Server cannot Open | ConfigMgr
Fix SCCM Report Server cannot Open a Connection Error ConfigMgr | Endpoint Manager | Configuration Manager 1
Fix SCCM Report Server cannot Open | ConfigMgr

NOTE! – Report Server Web Service is not configured. Default values have been provided to you. To access these default simply press the APPLY button, else change them and then press Apply.

1E Nomad
Fix SCCM Report Server cannot Open a Connection Error ConfigMgr | Endpoint Manager | Configuration Manager 2
Fix SCCM Report Server cannot Open a Connection Error ConfigMgr | Endpoint Manager | Configuration Manager 15
  • Wait to complete the configuration of web service URL for SSRS reporting service.
Fix SCCM Report Server cannot Open a Connection Error ConfigMgr | Endpoint Manager | Configuration Manager 3
Fix SCCM Report Server cannot Open a Connection Error ConfigMgr | Endpoint Manager | Configuration Manager 16
  • Now the configuration is completed.
  • Click on Exit button.
Fix SCCM Report Server cannot Open a Connection Error ConfigMgr | Endpoint Manager | Configuration Manager 4
Fix SCCM Report Server cannot Open a Connection Error ConfigMgr | Endpoint Manager | Configuration Manager 17
  • 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.

Fix SCCM Report Server cannot Open a Connection Error ConfigMgr | Endpoint Manager | Configuration Manager 5
Fix SCCM Report Server cannot Open a Connection Error ConfigMgr | Endpoint Manager | Configuration Manager 18
  • Click on Test Connection
  • Click on Next button
Fix SCCM Report Server cannot Open a Connection Error ConfigMgr | Endpoint Manager | Configuration Manager 6
Fix SCCM Report Server cannot Open a Connection Error ConfigMgr | Endpoint Manager | Configuration Manager 19
  • Enter the user name and password
  • Click the Next button.
Fix SCCM Report Server cannot Open a Connection Error ConfigMgr | Endpoint Manager | Configuration Manager 7
Fix SCCM Report Server cannot Open a Connection Error ConfigMgr | Endpoint Manager | Configuration Manager 20
  • Click the Next button to continue.
Fix SCCM Report Server cannot Open a Connection Error ConfigMgr | Endpoint Manager | Configuration Manager 8
Fix SCCM Report Server cannot Open a Connection Error ConfigMgr | Endpoint Manager | Configuration Manager 21
  • 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.

Fix Report Server cannot Open a Connection Error ConfigMgr | SCCM
Fix Report Server cannot Open a Connection Error ConfigMgr | SCCM
  • Click on 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.

SSRS Reporting - Fix Report Server cannot Open a Connection Error ConfigMgr
Fix Report Server cannot Open a Connection Error ConfigMgr

Resources

1 thought on “Fix SCCM Report Server cannot Open a Connection Error ConfigMgr | Endpoint Manager | Configuration Manager”

  1. 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?

    Reply

Leave a Comment

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