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_passwordWe 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_passwordHowever, 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 : RDMSCan 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