Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

qlikview ODBC connection string with sql server windows integrated authentication

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.

0 Replies