title: Setup a linked server connection from Microsoft SQL Server Management Studio to a MySQL Amazon Web Services MySQL RDS?
body: <p>I want to add a MySQL instances that is running as a RDS service through Amazon Web Services as a Linked Server in Microsoft SQL Server Management Studio.</p>
  
  <p>Does anyone know of any information on how I can set this up?</p>
  
  <p>What I want to be able to do is query data from my MySQL server from the local Micorsoft SQL server and then combine the data into other queries.</p>
  
  <pre><code>SELECT *
  FROM OPENQUERY(MySQL_Link, 'SELECT * 
                  FROM users
                  WHERE name = 'test')
  </code></pre>