kgozdzik

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!

I'm thinking the process has perhaps changed for how I should be logging in or maybe connecting to RDM. What are the current steps for creating a new credential entry within RDM using Powershell that you are following?

Any update on this?

$isrdm = (get-rdmdatasource | Where-Object {$_.name -eq 'is-rdm'}).id

$isrdm1 = $isrdm | select -ExpandProperty guid

Set-RDMCurrentDataSource -ID $isrdm1

$thegroup = "_Root\HST\Certificates"

$session = New-RDMSession -Group $thegroup -Type credential -Name $computerName; # this sets the session up which I'll be creating and using the set-rdmsession command below

Set-RDMSession -Session $session -Refresh; #(This part fails with the access denied error) (Normally this used to prompt me to login with my ID at RDM but doesn't seem to do that anymore. Still I'm able to query different RDM sessions without errors though.)

Update-RDMUI;

While logged in I can manually create the credential entry however when trying to use the Powershell command: Set-RDMSession it fails and throws a warning: "WARNING: Unable to save the entry; access denied" I'm using the latest version of Remote Desktop Manager Enterprise edition (2021.2.27.0 64-BIT) and using Powershell version 5.1. This used to work just fine where before I used to have to import the Remotedesktop Powershell module each time however now continuously fails saying access denied.

Commands such as get-rdmcurrentdatasource pulls up just fine. As well as commands such as get-rdmsession I can pull up specific credentials via powershell as well.