SCCM Data Warehouse Reports Error – Workaround

In my previous post, I showed the steps to install Data Warehouse service point role. At the end of same post, i mentioned about an error while accessing Data Warehouse reports. In this post I will present a workaround for SCCM data warehouse reports error. First of all, let me tell you that this is a known issue and is already documented here.

When you install Data Warehouse role, you will notice an error when you open any Data Warehouse reports. This is a known issue and even I experienced the same in my lab setup. Since the error can be fixed using a simple workaround, we will see how to do that.

SCCM Data Warehouse Reports Error

When you install Data Warehouse service point role, under reports you will find several data warehouse reports.

However when you try to run any report, you will see the below error.

An error has occurred during report processing. (rsProcessingAborted). Cannot create a connection to data source ‘AutoGen__39B693BB_524B_47DF_9FDB_9000C3118E82_’. (rsErrorOpeningConnection). A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0). The certificate chain was issued by an authority that is not trusted.)

Workaround for SCCM Data Warehouse Reports Error

Following are the steps that are part of this workaround to fix the SCCM Data Warehouse reports error.

Step 1 – Create Self-Signed Certificate

You must perform the below steps on the computer that hosts the data warehouse database.

Open IIS.

Click Server Certificates.

On the right pane, right-click and then click Create Self-Signed Certificate.

In this step specify a friendly name for the Certificate. You can specify it as “Data Warehouse SQL Server Identification Certificate”. Select the certificate store as Personal. Click OK.