Report builder error

LoolyJar 140 Reputation points
2023-03-17T08:38:50.29+00:00

I am using SCCM reporting, when I edit a report, it should open the report builder, but I get the error:

Unable to connect to data source

The certificate chain was issued by an authority that is not trusted.

How to fix it?

Microsoft Configuration Manager
0 comments No comments
{count} votes

Accepted answer
  1. AllenLiu-MSFT 39,056 Reputation points Microsoft Vendor
    2023-03-17T09:20:01.4533333+00:00

    Hi, @LoolyJar

    Thank you for posting in Microsoft Q&A forum.

    1. Make sure the SQL Server reporting services are up and running.
    2. Check SSRS log to see if there any error.
    3. We may encounter the report builder access error when we don't have SQL certificate installed on our computer. Exporting the ConfigMgr SQL Server Identification Certificate from SCCM server and importing into the computer resolves the report builder access error.

    For more details, we may check this article:

    https://www.prajwaldesai.com/sccm-sql-server-report-builder-access-error/


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Add comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

0 additional answers

Sort by: Most helpful