Create New Connection - Qlik Sense (Enterprise) - MS SQL Server

[h2k18]

Tried making connection from an Enterprise edition (Version Nov 2018) to Microsoft SQL server database using the following options with Windows integrated security option. 

1. ODBC
2. OLEDB
3. Microsoft SQL Server (connector provided by Qlik)

- Getting error on the enterprise edition version (ODBC, OLEDB and MS SQL server)
- Working fine on the Qlik Sense Desktop with OLEDB

Regards,
H

[jwjackso]

When you use windows integrated security for authentication against Microsoft SQL Server, Qlik Sense uses the service account running Qlik Sense as the authenticating account.  Does the Qlik Sense service account have access to the SQL Server database?

I believe Qlik recommends using a local database account for authentication.

[h2k18]

Yes Qlik service account has access. Actually it started working after few days. Not sure what was the root cause for the issue.