topic Re: Qlikview Access Point in QlikView https://community.qlik.com/t5/QlikView/Qlikview-Access-Point/m-p/1216081#M389464 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Wed, 07 Dec 2016 20:28:40 GMT Chip_Matejowsky 2016-12-07T20:28:40Z Qlikview Access Point https://community.qlik.com/t5/QlikView/Qlikview-Access-Point/m-p/1216073#M389456 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt; line-height: 1.5em;">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?</SPAN></P></BODY></HTML> Tue, 06 Dec 2016 21:15:39 GMT https://community.qlik.com/t5/QlikView/Qlikview-Access-Point/m-p/1216073#M389456 evansabres 2016-12-06T21:15:39Z Re: Qlikview Access Point https://community.qlik.com/t5/QlikView/Qlikview-Access-Point/m-p/1216074#M389457 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Which method you are using to Reload from access point.</P><P>Using Batch script or Direct reload built-in option</P></BODY></HTML> Tue, 06 Dec 2016 21:27:02 GMT https://community.qlik.com/t5/QlikView/Qlikview-Access-Point/m-p/1216074#M389457 krishnacbe 2016-12-06T21:27:02Z Re: Qlikview Access Point https://community.qlik.com/t5/QlikView/Qlikview-Access-Point/m-p/1216075#M389458 <HTML><HEAD></HEAD><BODY><P>Did you create the ODBC DSN in your server?</P></BODY></HTML> Tue, 06 Dec 2016 21:30:29 GMT https://community.qlik.com/t5/QlikView/Qlikview-Access-Point/m-p/1216075#M389458 Clever_Anjos 2016-12-06T21:30:29Z Re: Qlikview Access Point https://community.qlik.com/t5/QlikView/Qlikview-Access-Point/m-p/1216076#M389459 <HTML><HEAD></HEAD><BODY><P>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</P></BODY></HTML> Tue, 06 Dec 2016 21:32:15 GMT https://community.qlik.com/t5/QlikView/Qlikview-Access-Point/m-p/1216076#M389459 evansabres 2016-12-06T21:32:15Z Re: Qlikview Access Point https://community.qlik.com/t5/QlikView/Qlikview-Access-Point/m-p/1216077#M389460 <HTML><HEAD></HEAD><BODY><P>I believe so yes.</P></BODY></HTML> Tue, 06 Dec 2016 21:33:18 GMT https://community.qlik.com/t5/QlikView/Qlikview-Access-Point/m-p/1216077#M389460 evansabres 2016-12-06T21:33:18Z Re: Qlikview Access Point https://community.qlik.com/t5/QlikView/Qlikview-Access-Point/m-p/1216078#M389461 <HTML><HEAD></HEAD><BODY><P>"<SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">point, it fails." </SPAN></P><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">With which error message? Please check your log files<BR /></SPAN></P></BODY></HTML> Wed, 07 Dec 2016 12:53:59 GMT https://community.qlik.com/t5/QlikView/Qlikview-Access-Point/m-p/1216078#M389461 Clever_Anjos 2016-12-07T12:53:59Z Re: Qlikview Access Point https://community.qlik.com/t5/QlikView/Qlikview-Access-Point/m-p/1216079#M389462 <HTML><HEAD></HEAD><BODY><P>12/7/2016 11:34:10 AM:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Error: SQL##f - SqlState: 28000, ErrorCode: 18456, ErrorMsg: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'XXXXXX\QLIK_SERVICE'</P></BODY></HTML> Wed, 07 Dec 2016 16:36:34 GMT https://community.qlik.com/t5/QlikView/Qlikview-Access-Point/m-p/1216079#M389462 evansabres 2016-12-07T16:36:34Z Re: Qlikview Access Point https://community.qlik.com/t5/QlikView/Qlikview-Access-Point/m-p/1216080#M389463 <HTML><HEAD></HEAD><BODY><P>It seems to be obvious the error source : <SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f2f2f2;">Login failed for user 'XXXXXX\QLIK_SERVICE, this user does not have privileges on database</SPAN></P></BODY></HTML> Wed, 07 Dec 2016 18:29:05 GMT https://community.qlik.com/t5/QlikView/Qlikview-Access-Point/m-p/1216080#M389463 Clever_Anjos 2016-12-07T18:29:05Z Re: Qlikview Access Point https://community.qlik.com/t5/QlikView/Qlikview-Access-Point/m-p/1216081#M389464 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Wed, 07 Dec 2016 20:28:40 GMT https://community.qlik.com/t5/QlikView/Qlikview-Access-Point/m-p/1216081#M389464 Chip_Matejowsky 2016-12-07T20:28:40Z