ColdFusion 11 and Azure Database

Question

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.

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

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.

Ive tried lots of combinations and cant get it to work. Has anyone got this working and have an example connection string.

Answer 1

I finally worked it out. The examples I found online were wrong. Below are the settings you need. You will need to download the latest jdbc drivers from Microsoft and put the jar files into the lib directory of your ColdFusion installation (or in the CF classpath) and restart the CF server first.

• DataSource Type: Other
• Driver Class: com.microsoft.sqlserver.jdbc.SQLServerDriver
• Driver Name: Microsoft SQL Server Azure
• JDBC URL: jdbc:sqlserver://YOURSERVERNAME.database.windows.net:1433;databaseName=YOURDATABASENAME;user=YOURUSERNAME@YOURSERVERNAME;password=YOURPASSWORD;