Include remote desktop details in a connection string

[dafnis14]

Hi,

Is it possible to define RDP user & password details in a connection string in the script?

if not, is there any other way to bypass the manual logging in?

Thanks!

[petter]

I have a problem understanding why Remote Desktop would be used from a load script. Could you please explain your scenario in more detail?

[petter]

RDP is the protocol that is used by Microsoft Remote Desktop or MSTSC (Microsoft Terminal Services Client). The parameters for the latter programs can be set in an .rdp file. A connection string could not be used to specify parameters to these programs as they are not any kind of connectors or databases for Qlik to use.

Here is the documentation on parameters and .rdp files:

RDP Settings for Remote Desktop Services in Windows Server 2008 R2 | Microsoft Docs

Configuring Windows Remote Desktop from the command line

https://www.donkz.nl/overview-rdp-file-settings/

[dafnis14]

Hi Petter,

The request I have is to refer the same desktop app to various RDPs  in order to connect to the relevant database.

I thought that it would be nice to have the RDPs details defined as parameters for the load script.

I guess referring to connection string is misleading..

So based on the links you sent, I guess a BAT file would need to be executed from the script for each RDP.

Is this feasible?

Thanks!

[petter]

You should be able to have drives from the RDP session accessible but I don't see how you can connect to a database directly from your load script to a database even if you have RDP sessions established.

You should try to get a database login on each of the databases with the same login/username/identity as you would have for the RDP sessions and use a regular database connection from your load script. Then the login credentials could be saved and handled in the connection string.

[dafnis14]

Thank you very much, Petter!

Will give it a try... 🙂