Close Menu
    Facebook X (Twitter) Instagram
    Trending
    • Successful Adoption of a “Cloud First” Strategy
    • Speaking at Nordic Virtual Summit
    • Workplace Ninja User Group Denmark February Meetup
    • Workplace Ninja User Group Denmark Meetup – May 2022
    • Workplace Ninja User Group Denmark Meetup – April 2022
    • Speaking at Modern Endpoint Management Summit 2022
    • Speaking at Nordic Virtual Summit 2022 – 3nd Edition
    • CoLabora Recordings – January 2022
    RONNIPEDERSEN.COM
    • Home
    • Enterprise Mobility
      • Configuration Manager
      • Identity and Access
      • Information Protection
      • Intune
    • Cloud and Data Center
      • Data Center Management
      • Group Policy
      • Enterprise Security
      • Hyper-V
      • PowerShell
    • Guides
    • Webcasts
    • Links
    • About
      • Contact me
      • Disclaimer
    RONNIPEDERSEN.COM
    You are at:Home»Cloud and Data Center»SQL Report Builder; Unable to connect to data source

    SQL Report Builder; Unable to connect to data source

    1
    By Ronni Pedersen on December 3, 2014 Cloud and Data Center, Configuration Manager, Enterprise Mobility, Enterprise Security

    If you run System Center 2012 Configuration Manager and wants to use the Report Builder from a remote console, you might see the following error message:

    Unable to connect to data source
    The certificate chain was issued by an authority that is not trusted
    ——————————–
    A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider: 0 – The certificate chain was issued by an authority that is not trusted.)

    clip_image001

    To fix this little issue you need to do the following:

    Export the required certificate:
    1. On the Site Server (or the server hosting the SQL Reporting Service), start the MMC console with administrative rights.
    2. Add the Certificate snap-in for the Computer account.
    3. Expand Personal /Certificates, and select the certificate with the name of the server (Friendly Name: ConfigMgr SQL Server Identification Certificate).
    4. Right-click the Certificate, select All Tasks and then Export…
    5. On the Welcome to the Certificate Export Wizard page, click Next.
    6. On the Export Private Key page, select No, do not export the private key, and click Next.
    7. On the Export File Format page, select DER encoded binary X.509 (.CER), and click Next.
    8. On the File to Export page, click browse, and save the file to a shared folder that can be accessed from you client computers, and click Next.
    9. Click Finish.
    Import the certificate on the remote computer:
    1. On the Remote client, start the MMC console with administrative rights.
    2. Add the Certificate snap-in for the Computer account.
    3. Expand Trusted Root Certification Authorities /Certificates.
    4. Right-click the certificates, select All Tasks and then Import…
    5. On the Welcome to the Certificate Import Wizard page, click Next.
    6. On the File to Import page, click browse, and locate the certificate you exported in the previous step, and click Next.
    7. On the Certificate Store page, verify that the Trusted Root Certification Authorities, are selected and click Next.
    8. On the Completing the Certificate Import Wizard page, click Finish.

    That’s it… You should now be able to create your reports again from a remote console.

    Enjoy.

    +Ronni Pedersen

    • Tweet
    • Share 0
    • +1
    • LinkedIn 0

    Related

    Ronni Pedersen
    • Website
    • Facebook
    • X (Twitter)
    • LinkedIn

    My name is Ronni Pedersen and I'm currently working as a Cloud Architect at APENTO in Denmark. My primary focus is Enterprise Client Management solutions, based on technologies like AzureAD, Intune, EMS and System Center Configuration Manager. I'm is also a Microsoft Certified Trainer and Microsoft MVP in Enterprise Mobility.

    Related Posts

    Speaking at Nordic Virtual Summit

    Workplace Ninja User Group Denmark February Meetup

    Speaking at Modern Endpoint Management Summit 2022

    1 Comment

    1. Pingback: Modify built-in SCCM report - Lee's Infrastructure and Monitoring Blog

    Leave A Reply Cancel Reply

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

    Follow
    APENTO

    Follow APENTO here:

    Subscribe to Blog via Email

    Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    About
    My name i s Ronni Pedersen and I'm currently working as a Cloud Architect at APENTO in Denmark. My primary focus is Endpoint Management and Security, based on Microsoft technologies. I'm also a Microsoft Certified Trainer and a dual Microsoft MVP in both Security and Windows.
    Recent Posts
    • Successful Adoption of a “Cloud First” Strategy
    • Speaking at Nordic Virtual Summit
    • Workplace Ninja User Group Denmark February Meetup
    • Workplace Ninja User Group Denmark Meetup – May 2022
    • Workplace Ninja User Group Denmark Meetup – April 2022
    Archives
    TOP POSTS
    • Deploying Office 2016 using the Click-to-Run Deployment Tool
    • Find the TimeZoneName for your SCCM/MDT Deployments
    • How to Access the MBAM BitLocker Recover Keys directly in SQL
    • SCCM 2012 R2: Where is the SMSTS.log located?
    • Integrate Jamf Pro with Microsoft Intune
    RECENT COMMENTS
    • Sebi on Prepare for Co-Management: Migrate Intune Devices without user affinity
    • Vadim P on SCCM: Failed to Get Client Identity (80004005)
    • TM on Active Directory Based Activation in an multi domain environment
    • unkown on Setting OSDComputerName using CustomSettings.ini
    • TJ Scott on Setting OSDComputerName using CustomSettings.ini
    DISCLAIMER
    The content on this website is presented "as-is" with no guarantees. The use of scripts from this website is at your own risk. Always test before putting something in production! Opinions expressed are my own.
    © 2025 ThemeSphere. Designed by ThemeSphere.

    Type above and press Enter to search. Press Esc to cancel.