title: SSRS report builder 2.0 How to link 2 servers and run in one dataset
body: <p>I am trying to find a way of linking data from two servers in SSRS report builder 2.0</p>
  
  <p>ultimately using one dataset to query 2 databases in 2 different servers.</p>
  
  <p>The SQL that i have is very basic as shown below and i can run the query easily in SQL management studio.</p>
  
  <pre><code>select * from
  [server1].[DES].[dbo].[Daily] dr 
  LEFT JOIN [server2].[VES].[dbo].[Rou] mr
  ON dr.ID = mr.id
  </code></pre>
  
  <p>Also the access i have to the reporting server is read only so i cant really make any administrative changes to the configuration.</p>
  
  <p>I have explored the connection string to create a connection but it only allows me to connect to one server for each dataset. what i am trying to do is use one dataset </p>
  
  <p>Any help will be greatly appreciated as i am a junior in SQL and SSRS </p>
  
  <p>Using SSRS and MS SQL 2008 R2</p>