In order to use Windows Integrated Security with OLE DB and MS SQL - the Qlik Sense Engine service needs to be started with an account that also has WIS access to the in the security settings in your MS SQ server.
Here are my settings for example:
For clarity, Qlik Sense does not function like traditional BI and SQL-based query tools.
We pull data into our in-memory engine (QIX) and then you can perform the analysis using the data loaded into the app. Once the data is loaded into the app, you can also secure the app and its data in a few ways.
If I can understand more about your use case I can help you further.
Also if you have not seen these yet: New to Qlik Sense Videos - they will also help you become more familiar with Qlik Sense.
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.
Thanks and I'm pretty sure this answers it. I was wondering if the service account needed to be setup under the Security of the Database Server (in addition to the specific objects within the DB as has been our previous practice).
Assuming you have just created the login at the root Security level and also applied whatever granular permissions for that user at the DB?
PS will mark your answer as correct as soon as you confirm.
We are trying to get this working. We restarted the Qlik Sense Engine Service as stared above.
Now we can see the Engine Service running under the WIS account.
However, now when we try to access the hub or QMC we receive the following error.
Do we need to do the same for the other Qlik Services? Any help would be greatly appreciated.