Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Jeffrey_Li
Creator
Creator

ODBC DSN with Windows Authorization

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

Bo

2 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

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.

Jeffrey_Li
Creator
Creator
Author

Peter,

Thanks for your reply.

Bo