topic Re: Create encryption key for SharePoint Connector in Management & Governance

Create encryption key for SharePoint Connector

Giovanni_Civardi — Wed, 22 Mar 2023 02:10:44 GMT

trying to configure sharepoint connection in Nov2022 we are running into the “missing encryption key” issue described here:

https://community.qlik.com/t5/Official-Support-Articles/Qlik-Sense-Enterprise-on-Windows-Error-retrieving-the-URL-to/ta-p/1998751

it’s perfectly clear how to create/configure the key but we currently cannot run cmd as Qlik Sense service user account: due to customer policies (GPO) service accounts have admin rights locally on servers but they cannot interactively logon to servers. So runas command fails due to that limitation.

is there a workaround for this?

can we simply try to generate the key, run the specified command (QvWebStorageProviderConnectorPackage.exe /key {key} ) with our personal admin account and then move the key into service account appdata folder?

thanks in advance.

Re: Create encryption key for SharePoint Connector

Yves_Jezequel — Tue, 20 Feb 2024 22:47:46 GMT

Hi Giociva, could you find the solution for running the command with a personal admin account then transfer the encryption key to the service account?

Re: Create encryption key for SharePoint Connector

Ranganath_DR — Sun, 25 Feb 2024 19:39:55 GMT

Hi @Yves_Jezequel \ @Giovanni_Civardi ,

It may not work if you run it from other account. May be you can work with IT and get approval for login access and run it as it won't take long time to follow the article.

Re: Create encryption key for SharePoint Connector

AshishPatel — Fri, 22 Mar 2024 04:36:59 GMT

Hi guys,

Hope you can help me here. I tried to create encryption key using openssl to connect SharePoint wen connector in Qlik sense enterprise. But I am not able to generate the encryption key.

Do you know the reason why? All commands get executed correctly but no key is generated .

Any help would much appreciated

Re: Create encryption key for SharePoint Connector

Ajay_Ananthnarayan — Sat, 23 Mar 2024 22:03:46 GMT

Hello @AshishPatel @Giovanni_Civardi

Can you please follow https://community.qlik.com/t5/Official-Support-Articles/MISSING-ENCRYPTION-KEY-when-creating-a-data-connection/ta-p/2076666

Re: Create encryption key for SharePoint Connector

Giovanni_Civardi — Sun, 02 Jun 2024 12:47:48 GMT

hi @Yves_Jezequel and sorry for this late.

we ended up temporarely enabling the service account to do an interactive logon and run the command with that user. any other procedure does not work.

best,