The first datbase instance i connected to i was just givevn a username and password and all worked fine
The second DB im trying to connect to via a service account that was created . It didnt work . I was told the SQL dev owner needs to approve the qlik service account when it trys to access the DB in our company . (The Service account is linked to the Qlik service account , the ODBC User DSN name appears ) but connection fails as the QLIK SERVICE ACCOUNT(which is different from my service account) needs access to the DB
The third option is i use my windows integrated ID to logon to MS SQL DB's .
Which is best practise , will using my windows ID cause the model to fail if my password expires or i leave the company when deployed to PROD
Somone spoke of using a generic account , others a service account . Which route would you recommend .
