title: Connecting to Azure SQL via R
body: <p>The code below lets me connect to Azure SQL server via R.  However, I can only access a 'master' database and not the two databases below which I created.  Tables show as blank, any ideas?  Thanks </p>
  
  <pre><code>        library(RODBC) library(dplyr) library(DBI) 
  
      conn &lt;- RODBC::odbcConnect(
          &gt; dsn = "XXX",   uid = "XXX",   pwd = "XXX" )
          &gt; 
          &gt; db_list &lt;- RODBC::sqlQuery(   channel = conn,   query = "SELECT name
          &gt; FROM Master..sysdatabases")
          &gt; 
          &gt; test &lt;- sqlTables(conn)
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/BzF2V.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BzF2V.png" alt="enter image description here"></a></p>