topic ODBC DSN with Windows Authorization in QlikView

ODBC DSN with Windows Authorization

Jeffrey_Li — Thu, 21 Sep 2017 15:52:13 GMT

Hi,

We have a Windows ODBC DSN on Qlikview server for SQL Server db, and it uses Windows authorization to connect to database. If a developer uses the following code in his script:

ODBC CONNECT TO [MySQLODBC];

When his QVW runs automatically by a trigger, whose Windows authorization does it use?

Thanks

Re: ODBC DSN with Windows Authorization

Peter_Cammaert — Thu, 21 Sep 2017 16:07:53 GMT

It tries to use the authorization of the Service Account that is running the QlikView services. If it really has an authorization to access your DBMS.

If that is not going to work, you can try filling the Section Access fields with credentials that do have access to your SQL Server DB. But the best/simplest/easiest solution would be to give the service account Read access to your DB.

Re: ODBC DSN with Windows Authorization

Jeffrey_Li — Thu, 21 Sep 2017 18:17:44 GMT

Peter,

Thanks for your reply.