CF2021 azure sql server connections failing

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

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.