Prompted to configure OTP 2FA for SQL data source every launch

Implemented

Prompted to configure OTP 2FA for SQL data source every launch

avatar

Hello, we recently upgraded from RDM version 2022.2.29.0 to 2022.3.24.0 and are having a problem where we're prompted to configure 2-factor authentication for our SQL data source every time RDM is launched.

We are using the Custom login authentication type to connect to the SQL instance, and looking at the release notes for version 2022.3.21.0 I see an item "Fixed 2FA not working on SQL server with custom logins" which I thought may be related or potentially regressed in 2022.3.24.0.

Some further details that may be relevant:

  • RDM is running on a Windows Server 2019 RDS/Terminal Server
  • When upgrading the database the "original" version was 782, target 809
  • We're using a SQL data source with the Custom login authentication type
  • The 2FA type we're trying to configure is Authenticator (TOTP)
  • A Security Provider Passphrase is set against the data source
  • After configuring 2FA the data source connects and works as expected
  • Simply closing and reopening RDM causes the 2FA configuraiton prompt to reappear, the exact wording is: "You need to configure a 2-factor authentication to get access to this data source. Configure/Cancel"
  • The problem occurs when RDM is run under a completely new Windows User Profile i.e. where no previous RDM Registry entries/AppData content/Local Data Sources exist.


Please let me know if you need any further info. Thanks.

All Comments (5)

avatar

Hello,

A case is open with the engineering department for that issue. I will keep you updated regarding that!

Best Regards,

Etienne Lord

avatar

Hello Etienne, thanks for the update.

Just to confirm, it sounds like this is a known issue? I'd just like to update my team. Thanks!

avatar

Hello,

We have 3 or 4 other similar cases, we are still investigating on our side, but yes, it is a known issue!

Best Regards,

Etienne Lord

avatar

Hello, thanks again for confirming.

Please just let me know if you need any more info to help with troubleshooting.

avatar

Hello,

Same facts here with Integrated Security.
The <EncryptedDataSources> block disappear from %appdata%\Devolutions\RemoteDesktopManager\RemoteDesktopManager.cfg.
If a take that block from a previous CFG file, there is no prompt to reset the 2FA.

Hope this will help.

Best Regards