RDM & Powershell: Switching from datasource SQL server to DVLS
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!
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
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!
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