title: ColdFusion 11 and Azure Database
body: <p>I cant get ColdFusion to connect to an Azure Database. We have an old ColdFusion based admin routine that requires a datasource and we are moving from aws to azure.</p>
  
  <p>After reading online, it seems it wont work unless you use an Other datasource and jdbc driver and settings. However in ColdFusion 11, it just wont validate and tells me</p>
  
  <pre><code>Connection verification failed for data source: MyData
   com.microsoft.sqlserver.jdbc.SQLServerException: The connection string contains a badly formed name or value.
   The root cause was that: com.microsoft.sqlserver.jdbc.SQLServerException: The connection string contains a badly formed name or value.
  </code></pre>
  
  <p>Ive tried lots of combinations and cant get it to work. Has anyone got this working and have an example connection string.</p>