SQL Active Directory Integration and RDM Android 13

Hi,


The upcoming version will introduce Active Directory session support, enabling you to connect to your Active Directory and perform various operations such as: adding users, resetting passwords and unlocking users. It's important to note that this functionality is different from connecting to SQL Server using Integrated Security, as the current development tools provided by Microsoft do not offer support for the latter.

As of now, you have two options:

1. Configure your SQL Server to utilize Mixed Mode Authentication and create database users to connect to your data source using SQL Server Authentication. While on Windows, you will be able to continue connecting to your SQL Server with your Active Directory accounts. On RDM Android, configure your SQL Server data source to use the username and password you've created on your SQL Server. If you need to access your SQL Server data source remotely, it's advisable to do so while connected to your office VPN.
2. Consider switching to the DVLS data source (Devolutions Server data source). This option offers enhanced security and a broader range of advanced features. You can explore the details here: DVLS Data Source.

Best Regards,

Hi,

Thank you for the above info.
Can you please confirm that RDM (android App) version 2024.1.4.1 is supporting (SQL Server) Active Directory log-in?

Thanks,
Idan

1. Configure your SQL Server to utilize Mixed Mode Authentication and create database users to connect to your data source using SQL Server Authentication. While on Windows, you will be able to continue connecting to your SQL Server with your Active Directory accounts. On RDM Android, configure your SQL Server data source to use the username and password you've created on your SQL Server. If you need to access your SQL Server data source remotely, it's advisable to do so while connected to your office VPN.

Best Regards,

We are using license RDM version.
If there is not AD support, in case configuring mixed mode authentication, will I be able to use the same license for me once as AD user and another timer as internal SQL auth mode?

Hello,

Microsoft does not support AD Interactive login on mobile as of right now, which means it is currently not supported on RDM Android. You can keep track of the feature request sent to Microsoft here : https://github.com/dotnet/SqlClient/issues/2062.
As for your license question, if you bought the necessary licenses on your Windows setup, there should be no issue connecting to your SQL Server datasource using your database user on Android.

Regards,

Nicholas Lachapelle