title: Cannot connect SSRS VM to SQL Azure Database
body: <p>I have an SQL Azure database, and have a an Azure CM which is running SSRS.</p>
  
  <p>I can build a report in Visual Studio, and see my data when I preview it.</p>
  
  <p>I can connect to the Azure database from the SQL server management studio on the VM fine.</p>
  
  <p>However, when I deploy the report to the reporting server I get a very generic and unhelpful message of:</p>
  
  <p><strong>An error has occurred during report processing. (rsProcessingAborted)
  Cannot create a connection to data source 'SQLAzure'. (rsErrorOpeningConnection)
  The report server has encountered a configuration error. (rsServerConfigurationError)</strong></p>
  
  <p>I have added both the public and private IP addresses of the VM to the database firewall rules, and have also opened outbound TCP port 1433 to allow the connection to the database.</p>
  
  <p>Would appreciate any help as to what the cause of this could be.</p>