qlikview ODBC connection string with sql server windows integrated authentication

Fri, 17 Feb 2017 15:34:59 GMT

Hi Guys

A quick question, maybe someone has the experience, please share with me:

Normally the odbc connection string is like below:

ODBC CONNECT TO XXXX(XUserId is ABCDEF, XPassword is HASFDSAFD);

our production environment is using service account, so there is no password, I think the following string is correct, but no chance to test, our UAT is in not using service account.

ODBC CONNECT TO XXXX;

can any one confirm it is good enough?

We are using sql server, and in prod environment, we use service account instead of a userid/password pair.

topic qlikview ODBC connection string with sql server windows integrated authentication in QlikView

qlikview ODBC connection string with sql server windows integrated authentication