When a SQL Server Reporting Services (SSRS) report is created a data source is used to create and test the report, so 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. 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

· Click on the Properties tab

· 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.

clip_image004

· 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)

clip_image006

· Click on the Apply button

clip_image008

· Click on the View tab in order to ensure that that report works correctly.

How to Change the SSRS Data Source - View Tab

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.