title: How to deploy SSRS report with multiple data sources?
body: <p>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.</p>
  
  <p>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?</p>
  
  <p>Any help will be greatly appreciated.</p>
  
  <p>Thanks</p>