When a SQL Server Reporting Services (SSRS) report is created, a data source is used to connect the report to database. As a Microsoft Endpoint Configuration Manager (MEMCM / MECM / SCCM / ConfigMgr ) Administrator we can find many SSRS reports on the internet. But when you upload SSRS Report (RDL) to your SSRS website site you will get an error about connecting the the data source. This blog post shows you how to change the SSRS DataSource. The data source may not exist on your SSRS site therefore you will need to point it to a data source that does exist on your site.

How to Change a SSRS DataSource for a Report

Use these steps to re-point the data source to an existing data source.

Connect to your SSRS site

Browse to the appropriate folder

Click on the report where you want to change the data source

After that, click on the Properties tab

Again, click on the Data Sources link (see it on the left-hand side)

How to Change the SSRS Data Source - Data Sources Node

Click on the Browse button

Expand Home | <Your SSRS folder name> until you find the shared data source that you are trying to locate.


Select the data source

Note: {5C6358F2-4BB6-4a1b-A16E-8D96795D8602} is the default ConfigMgr data source.

Click on the OK button (you might need to scroll-down the page to see it)


Click on the Apply button


Afterwards, click on the View tab in order to ensure that that report works correctly.

How to Change the SSRS Data Source - View Tab

As a matter of fact, we can see from viewing the report that everything is now working as we expect. We can return to our regular MEMCM duties!

If you have any questions about how to change the SSRS DataSource, please leave me a note in the comment section below or contact me @GarthMJ. Don’t forget that you can subscribe to my RRS feed to stay on top of the latest trips and tricks.