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.
Environment:
Qlik Sense Enterprise on Windows any version
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.
Password policies on various data sources may also impact this, such as password policies in Oracle.
Resolution:
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
If a user attempts to create an ODBC data connection to Oracle DB and results with error: "You do not have access to the data source ":
- (ref Oracle)
Passwords can contain any single-byte, multibyte, or special characters, or any combination of these, from your database character set, with the exception of the double quotation mark (") and the return character. If a password starts with a non-alphabetic character, or contains a character other than an alphanumeric character, the underscore (_), dollar sign ($), or pound sign (#), then it must be enclosed in double quotation marks. Otherwise, enclosing a password in double quotation marks is optional.
