(user deleted)
can't connect to RDM datasource using PowerShell Module to Repository in Azure MSSQL
Hi Richard!
I recently Updated my Powershell Module to Version 2021.2.0.36. Currently it is possible to set a current connection like this:
Set-RDMCurrentDataSource -ID "90794294-ebed-4e5b-a345-e0cb1fe21ff6"The issue is, that this will result in the error message
Cannot open server "example.com" requested by the login. The login failed.
[] Offline gehen [] Abbrechen [?] Help (default is "Offline gehen"): Abbrechen
If I select "Offline gehen" (go offline) the following will result after executing the Get-RDMCurrentDataSource Command:
ID : 90794294-ebed-4e5b-a345-e0cb1fe21ff6
IsConnected : True
IsOffline : True
Name : azuresql-server
Type : SQLServerI also tried solving the issue by adding the parameters -Username and -Password, but that made no difference.
Is there any Update on this matter?
Best regards,
Tim Krehan
can't connect to RDM datasource using PowerShell Module to Repository in Azure MSSQL
is there any roadmap or time planning with that MFA Support?
can't connect to RDM datasource using PowerShell Module to Repository in Azure MSSQL
Hi All :)
I recently updated to RDM Version 2021.2.16.0 64-BIT.
In the Documentation is stated, that from Version 2021.2.8.0 on the RermoteDesktopManager Module from the Powershell Gallery must be imported.
That I did with the most current version at this Point (2021.2.0.24). Sad enough I can't connect to my Datasource in Azure anymore.
The UI works fine, so i don't think it's an issue with the connectabillity itself, more a issue with the MFA required by the Azure Database.
I have two RDMDataSources configured locally:
ID IsConnected IsOffline Name Type
-- ----------- --------- ---- ----
7bc6a7e8-7928-4b6a-92c2-defc6592a922 False False Lokale Datenquelle SQLite
90794294-ebed-4e5b-a194-e1cb1fe21ff6 False False azure-database SQLServerIf I try to connect to the SQLite datasource it works just fine:
$rdmDataSource = Get-RDMDataSource -Name "Lokale Datenquelle"
Set-RDMCurrentDataSource -DataSource $rdmDataSource
Update-RDMUI
Get-RDMCurrentDataSource |ftID IsConnected IsOffline Name Type
-- ----------- --------- ---- ----
7bc6a7e8-7928-4b6a-92c2-defc6592a922 True False Lokale Datenquelle SQLiteIf I try the same commands with the other datasource:
$rdmDataSource = Get-RDMDataSource -Name "azure-database"
Set-RDMCurrentDataSource -DataSource $rdmDataSource
Update-RDMUI
Get-RDMCurrentDataSource |ftI get the following output:
ID IsConnected IsOffline Name Type
-- ----------- --------- ---- ----
90794294-ebed-4e5b-a194-e1cb1fe21ff6 False False azure-database SQLServerI am suspecting, that it may be an issue related to the MFA required by that datasource.
I would be very happy, if someone can help me find the error, Thanks!
Greetings