Qlikview Access Point

[evansabres]

We built an application that utilizes an ODBC connection connecting to a SQL database. When we re-load the document locally on our workstations and /or on the server, the application runs fine. However, when we set the application up to reload on the access point, it fails. We have never used a SQL connection before, so we may be doing something incorrectly in the configuration of the application?

[krishnacbe]

Hi,

Which method you are using to Reload from access point.

Using Batch script or Direct reload built-in option

[Clever_Anjos]

Did you create the ODBC DSN in your server?

[evansabres]

I am uncertain. If I had to guess, the direct reload built-in option. I scheduled a task within the access point to reload at a certain time

[evansabres]

I believe so yes.

[Clever_Anjos]

"point, it fails."

With which error message? Please check your log files

[evansabres]

12/7/2016 11:34:10 AM:       Error: SQL##f - SqlState: 28000, ErrorCode: 18456, ErrorMsg: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'XXXXXX\QLIK_SERVICE'

[Clever_Anjos · Accepted solution]

It seems to be obvious the error source : Login failed for user 'XXXXXX\QLIK_SERVICE, this user does not have privileges on database

[Chip_Matejowsky]

Agree with Clever. A simple test would be to login to a computer with QlikView Desktop using the service account that is running the QlikView Distribution Service and attempt to run the reload. If you get the same error, then you have a permissions issue for the service account.