ODBC system DSN Windows authentication

[linoyel]

I have an SQL Server data source to which it's possible to connect using Windows authentication only.

When I run my QV document from QV it's OK but when I'm trying to run it from QMC i get an error that it couldn't connect to my user.

What's wrong?

Is it not possible to run docs from QMC using Windows authentication ODBC connection?

[vardhancse · Accepted solution]

For Qlikview service accounts we should give access to SQL, with out that in QMC we can't reload data directly to QMC from SQL

[linoyel]

I understand.

Thank you.

[vardhancse]

When ever we create any table in DB level we should run grant statement for the Qlikview service accounts, if not QMC will get authentication issue from DB level.