• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

CF2021 azure sql server connections failing

Community Beginner ,
Dec 03, 2021 Dec 03, 2021

Copy link to clipboard

Copied

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!

 

Views

107

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Dec 03, 2021 Dec 03, 2021

Copy link to clipboard

Copied

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. 


/Charlie (troubleshooter, carehart.org)

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Dec 03, 2021 Dec 03, 2021

Copy link to clipboard

Copied

LATEST

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation