"You do not have access to the data source" when creating data connection in Qlik Sense
Article Number: 000019259 | Last Modified: 2018/06/12
Despite having access rights to the database source, "You do not have access to the data source" is displayed when creating data connection in QlikSense
When creating a connection in QlikSense, you must make sure that the service account has proper rights to do so.
If you are running services with "Local system", depending on your domain/local policies, it may be that "local system" is being restricted regarding actions it can perform.
The recommendation is to always run QlikSense services as a specified account, except for QlikSense Repository Database service that should always be run as local system.
If you are running QlikSense services as "local system":
- Go to the services console and change the account to run services to an account having local administrator rights on the machine. (Only QlikSense Repository Database service should always be run as local system.)
- Restart all services