I have two different databases on two different servers and I need data from both the databases for two different datasets associated with two tables in report.
The problem is I am not allowed to deploy the report from BIDS and report will be deployed by Upload File option in report manager, so how to deploy this report with multiple data sources?
Any help will be greatly appreciated.
Thanks
After uploading the report to Report Manager, go to the report properties and edit the data sources there. An easy way to get to the report properties page is click Show Details button when you are in Report Manager. Then, just click the properties icon under the Edit column. Either that, or view the report (which should fail to run initially), and click the Properties tab at the top page.
Once you are there, click Data Sources. You will see one entry per data source. Configure each appropriately.
