Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (3)

Resolved Azure SQL Server MFA Authentication

  1. How-to
0
Votes
Undo
  1. Larry Pettit
    Larry Pettit
  2. PowerBuilder
  3. Sunday, 13 August 2023 18:33 PM UTC

As best as I can tell, it is currently impossible to connect the PB IDE or a PB Application to Azure SQL Server using MFA Authentication, comparable to the "Azure Active Directory - Universal with MFA" authentication option in SQL Server Management Studio.

I was hoping this capability would be released with PB 2022 R2, but there is no mention in the release notes.

Could you please verify this is not currently possible?

If it is still impossible, what would be considered the current best practice for authenticating a PB application to Azure SQL Server?  Manually setting up logins, database users, and passwords in Azure SQL Server?  I'm not very fond of this option.  I really need an SSO solution.

 

Thanks!!!

Issue with WebBrowser control deployment
Minimize window only show half
Responses (3)
Peter Pang @Appeon
Peter Pang @Appeon Accepted Answer Pending Moderation
  1. Thursday, 17 August 2023 02:57 AM UTC
  2. PowerBuilder
  3. # 1

Hi Larry,

 

Azure SQL Server MFA Authentication is not yet supported in PB2022 R2. We have documented your requirements and will consider it in later versions of development.

But PB2022 R2 did upgrade the ADO.NET driver. Please check whether Active Directory Password Authentication and Active Directory Integrated Authentication in SQL Server are suitable for you.

 

Best Regards,

Peter

Comment
Larry Pettit
  1. Larry Pettit
  2. Thursday, 17 August 2023 12:15 PM UTC
Is there any link you can provide that would tell me more about the upgrade to the ADO.NET driver?
  1. Helpful
Larry Pettit
  1. Larry Pettit
  2. Thursday, 17 August 2023 12:22 PM UTC
Does it work with Microsoft.Data.SqlClient 2.1.0? Sorry, I can't find current PowerBuilder documentation on what is supported in this regard.
  1. Helpful
Peter Pang @Appeon
  1. Peter Pang @Appeon
  2. Friday, 18 August 2023 00:38 AM UTC
refer to link:https://docs.appeon.com/pb/whats_new/ADONET_driver_upgrade.html
  1. Helpful
There are no comments made yet.
Larry Pettit
Larry Pettit Accepted Answer Pending Moderation
  1. Monday, 14 August 2023 15:52 PM UTC
  2. PowerBuilder
  3. # 2

It seemed appropriate to ask and receive answers to the following prior to requesting an enhancement in case an alternative already exists:

<Could you please verify this is not currently possible?

If it is still impossible, what would be considered the current best practice for authenticating a PB application to Azure SQL Server?  Manually setting up logins, database users, and passwords in Azure SQL Server?  I'm not very fond of this option.  I really need an SSO solution.>

 

Comment
There are no comments made yet.
Francisco Martinez @Appeon
Francisco Martinez @Appeon Accepted Answer Pending Moderation
  1. Monday, 14 August 2023 15:43 PM UTC
  2. PowerBuilder
  3. # 3

Hi Larry,

Just as a suggestion, if you wish for a feature to be implemented on PB, you should submit an enhancement request through our support portal, so that our team become aware that desire for a specific feature exists, and can be considered in the roadmap for future development if the feature becomes requested enough.

 

Regards,
Francisco

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.