RDM & Powershell: Switching from datasource SQL server to DVLS

Resolved

RDM & Powershell: Switching from datasource SQL server to DVLS

avatar

Hello,

Up till now, we're using an (on premise) Microsoft SQL server as backend for our Remote Destkop Manager (RDM) with using a local SQL server account.

Setting up is done like this:

# Setup a new datasource
$datasource = New-RDMDataSource -Name $rdm_datasource_name -SQLServer -Server $rdm_datasource_server -Database $rdm_datasource_database_name -Username $rdm_datasource_username -Password $rdm_datasource_secure_password
Set-RDMDataSource $datasource

# Setup default RDM datasources
Set-RDMCurrentDataSource -DataSource $datasource -Username $rdm_datasource_username -Password $rdm_datasource_secure_password


We can then can then retrieve sessions, like Get-RDMSession

Now, we're in the transition of switching to DVLS. Now I setup the datasource like this. For getting started, I tried with the DVLS local admin account (created upon setup of DVLS)

# Setup a new datasource (witht a different name then SQL server example from above)
$datasource = New-RDMDataSource -Name $rdm_datasource_name -DVLS -Server $rdm_datasource_server -Username $rdm_datasource_username -Password $rdm_datasource_secure_password
Set-RDMDataSource $datasource

# Setup default RDM datasources

Set-RDMCurrentDataSource -DataSource $datasource -Username $rdm_datasource_username -Password $rdm_datasource_secure_password


However, I cannot retrieve any sessions:
Get-RDMSession : Connection not found.

But datasource looks fine?

Get-RDMDataSource


ID          : 30b7ae00-c227-41e1-982c-c286393e9599
IsConnected : True
IsOffline   : False
Name        : dvls-stg
Type        : RDMS

ID          : b1c0588f-750b-4dca-b305-015f88be2bec
IsConnected : False
IsOffline   : False
Name        : Local Data Source
Type        : SQLite

 Get-RDMCurrentDataSource


ID          : 30b7ae00-c227-41e1-982c-c286393e9599
IsConnected : True
IsOffline   : False
Name        : dvls-stg
Type        : RDMS


Can anyone help pointing out this issue? thanks!

All Comments (3)

avatar

Hello,

What DVLS version are you using?

What Devolutions.PowerShell module version are you using? You can get the information with the Get-RDMInstance cmdlet.

What do you get with Get-RDMCurrentVault?

Do you see any relevant error messages in Reports - Data Source Logs on the DVLS web UI?

Best regards,

Érica Poirier

avatar

We're using DVLS version 2023.2.5.0 and Powershell module version 2022.3.1.8.

When I performed Get-RDMCurrentVault, it turned out to be I was using the wrong vault!

With Set-RDMCurrentVault -ID $rdm_vault_to_use.ID I got it all working!

Thanks!

avatar

Hello,

Thank you for your feedback and glad that you found out that you were in the wrong vault.

About the module version, I would recommend you to update it to the latest 2023.2.0.6 version.
https://www.powershellgallery.com/packages/Devolutions.PowerShell/

Best regards,

Érica Poirier