Users

All Posts (3)

avatar

(user deleted)

Disabled

can't connect to RDM datasource using PowerShell Module to Repository in Azure MSSQL

avatar
avatar
avatar
avatar
avatar

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        : SQLServer

I 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

avatar
avatar
avatar
avatar
avatar

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

avatar
avatar
avatar
avatar
avatar

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             SQLServer

If 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 |ft

ID                                   IsConnected IsOffline Name                 Type
--                                   ----------- --------- ----                 ----
7bc6a7e8-7928-4b6a-92c2-defc6592a922        True     False Lokale Datenquelle SQLite

If I try the same commands with the other datasource:

$rdmDataSource = Get-RDMDataSource -Name "azure-database"
Set-RDMCurrentDataSource -DataSource $rdmDataSource
Update-RDMUI
Get-RDMCurrentDataSource |ft

I get the following output:

ID                                   IsConnected IsOffline Name                         Type
--                                   ----------- --------- ----                         ----
90794294-ebed-4e5b-a194-e1cb1fe21ff6       False     False azure-database          SQLServer

I 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

1 - 3 of 3 items