Is it possible to sign into an Azure Sql datasource where our login mode is Active directory interactive (with MFA support)?
Is it possible to sign into an Azure Sql datasource where our login mode is Active directory interactive (with MFA support)?
It's been a few years that have passed where your old module which you had to manually load worked just fine signing into an Azure SQL database. It used to come up and prompt for the user name in a separate window, I could click the name and login. Ever since the new module, I have never been able to sign into an Azure SQL datasource via Powershell.
I know it's possible this has been asked before but is this available yet? Is it possible to use an application password?
PS C:\Github> $isrdm = (get-rdmdatasource | Where-Object {$_.name -eq 'is-rdm'}).id
$isrdm1 = $isrdm | select -ExpandProperty guid
Set-RDMCurrentDataSource -ID $isrdm1
Cannot open server "servernamehere" requested by the login. The login failed.
Doesn't seem possible to manipulate an RDM (Azure SQL) datasource using powershell commands. This would definitely save some time if I could get this working again. Appreciate any help!
All Comments (3)
Hi,
Version 2023.1, that is scheduled to release somewhere in the upcoming weeks, will be able to connect to a SQL Azure in interactive (2FA) mode.
Until then, your only option to connect would be to use a SQL user instead of a AD user.
Regards
Jonathan Lafontaine
I just upgraded my RDM to 2023.1.20, uninstalled the module, reinstalled the module from the PSGallery. Stil getting the same error when trying to connect using an Azure SQL datasource with MFA. What is interesting is that Get-RDMInstance returns 2022.3.1.7 as the ApplicationVersion. Do I need to do something else to "upgrade" the Module?
Also, when you import the module, it says it is deprecated and to use Devolutions.PowerShell. Is that accurate and are the commands the same?
I'm on PS Core 7.3.3 in case that matters.
EDIT: Switched to the Devolutions.PowerShell module and everything is working now including the MFA / Interactive login popup. It would be good to update the docs about the new module as everything still references the RemoteDesktopManager module from what I can see.
Hi,
Yes, the message is accurate. The release compatible with RDM 2023.1 is now called Devolutions.PowerShell.
You'll need this new module to connect to Azure with MFA. Even though the name has changed, the commands are the same.
Let me know if you experience any issues with the new module.
Regards.
Jonathan Lafontaine