title: In Azure Synapse, how do I setup a SQL Server that can access Datalake Storage?
body: <p>I have setup a Synapse environment and filled my storage account with some sample Parquet files. I have then created a serverless SQL database and created some external tables over the Parquet files. All this works fine and I can query these tables fine from the Synapse UI and SSMS using AD Authentication.</p>
  <p>The problem is I want to connect an app to the serverless SQL database which doesn't support AD authentication. Therefore I want to connect it using a standard SQL account. I have setup a SQL account (username and password) and I'm able to connect through SSMS, but not query any tables due to this error...</p>
  <blockquote>
  <p>External table 'TableName' is not accessible because content of directory cannot be listed.</p>
  </blockquote>
  <p>I assume this is a double-hop authentication problem because the SQL user doesn't have access to the storage account? I can't seem to find any guides on how to do this. Does anyone know?</p>