Qlik Community

Ask a Question

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
h2k18
Contributor II
Contributor II

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

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

Labels (3)
2 Replies
jwjackso
Specialist II
Specialist II

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
Contributor II
Contributor II
Author

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