Fix Report Server cannot Open a Connection Error ConfigMgr | SCCM

1
Fix SSRS Reporting

Let’s see how to fix 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“.

http://sqlmemcm/Reports/Pages/Folder.aspx

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

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 Report Server cannot Open a Connection Error ConfigMgr | SCCM
Fix Report Server cannot Open a Connection Error ConfigMgr | SCCM
  • 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 Report Server cannot Open a Connection Error ConfigMgr | SCCM
  • Make sure the SQL reporting service is running.
Fix Report Server cannot Open a Connection Error ConfigMgr | SCCM
Fix Report Server cannot Open a Connection Error ConfigMgr | SCCM
Fix Report Server cannot Open a Connection Error ConfigMgr | SCCM 1

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.

Fix Report Server cannot Open a Connection Error ConfigMgr | SCCM 2
  • Wait to complete the configuration of web service URL for SSRS reporting service.
Fix Report Server cannot Open a Connection Error ConfigMgr | SCCM 3
  • Now the configuration is completed.
  • Click on Exit button.
Fix Report Server cannot Open a Connection Error ConfigMgr | SCCM 4
  • 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 Report Server cannot Open a Connection Error ConfigMgr | SCCM 5
  • Click on Test Connection
  • Click on Next button
Fix Report Server cannot Open a Connection Error ConfigMgr | SCCM 6
  • Enter the user name and password
  • Click the Next button.
Fix Report Server cannot Open a Connection Error ConfigMgr | SCCM 7
  • Click the Next button to continue.
Fix Report Server cannot Open a Connection Error ConfigMgr | SCCM 8
  • 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 COMMENT

  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?

LEAVE A REPLY

Please enter your comment!
Please enter your name here

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