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?
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.
