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)
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.
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.
MyDataSource is used by all the reports in my SSRS system. I need to test them against another database. BUT I do not know the password for the connection in MyDataSource.
How can I COPY (or DUPLICATE or Save Off) an SSRS DataSource so that I can make changes to access a new database, test my reports, and then switch it back easily?
If you don’t know the password then you can’t. I would create a second DS and point your reports to that DS. if you are lucky you can find a PowerShell script to help automated this for you.