CF2021 azure sql server connections failing

[AustinValley]

I'm attempting to use the native driver for my datasource on AZURE.  When verifing, I get

[Macromedia][SQLServer JDBC Driver][Macromedia][SQLServer JDBC Driver]Attempted connection to the secondary server <HOST>:11000 failed.

When I use the JDBC driver from microsoft, I do not have this issue.

Any suggestions on how to configure the native driver to resolve this error?  I've tried matching the JDBC connection string in the additional settings, but still get this error with the native driver.

Thanks!

[Charlie Arehart]

By native driver, you mean the one that comes with CF, right, since your error references Macromedia? (Some folks would refer to a jdbc driver you got from Ms to be the "native" one for sql server.)

Anyway, the jdbc url and connection strings differ significantly between the two, so making them match is not the answer.

As for why you'd get that error about a secondary server, do you have any settings in the dsn (including any advanced settings) that refer to that secondary server? If not, is the host name at least the same as the server in the dsn? What about the port?

Finally, what version of cf is this, a d what update level? That could affect the dB support provided by the adobe/Macromedia driver. And is the sql server really Azure sql db? Or sql server running in an Azure VM, perhaps? 

All these affect what is supported, how to configure it, etc. 

[Dave Watts]

CF comes bundled with a set of DataDirect Connect for JDBC drivers. The SQL Server one is not the same as the Azure SQL one. CF doesn't come with the Azure SQL one. I suspect you'd have to use the Azure SQL one, or download one from Microsoft. In either case, you'd have to select "other", then fill in the blanks accordingly.

https://www.progress.com/jdbc/microsoft-azure-sql-database

Dave Watts, Eidolon LLC