topic Re: Create New Connection - Qlik Sense (Enterprise) - MS SQL Server in Connectivity & Data Prep

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

h2k18 — Thu, 23 Dec 2021 14:53:51 GMT

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

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

jwjackso — Wed, 19 Jun 2019 20:56:30 GMT

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.

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

h2k18 — Fri, 28 Jun 2019 14:18:59 GMT

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