Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Windows integrated security is not working for SQL Server

When using the Qlik Sense server product, I am getting an error when trying to connect to SQL Server using Windows Integrated security via OLEDB.  Does anyone know why this is happening?  It works ok if I type in a database user/password.

1 Solution

Accepted Solutions
Employee
Employee

Re: Windows integrated security is not working for SQL Server

i agree.  If you were using desktop it would connect with your own credentials.  On the server it will use the service account that runs the 'engine service' i believe.

4 Replies

Re: Windows integrated security is not working for SQL Server

My guess is that the service account that the Qlik Sense service runs as is not known and/or authorized to the SQL Server.


talk is cheap, supply exceeds demand
Employee
Employee

Re: Windows integrated security is not working for SQL Server

i agree.  If you were using desktop it would connect with your own credentials.  On the server it will use the service account that runs the 'engine service' i believe.

Employee
Employee

Re: Windows integrated security is not working for SQL Server

Hello Nilesh,

Both Jonathan and Gysbert are correct in their thinking.

You need to take a look at the credentials that the Engine service is started with

That ID should be the ID that is authorized to use M SQL.

Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.

Regards,

Mike Tarallo

Qlik

Not applicable

Re: Windows integrated security is not working for SQL Server

Thanks for your help and quick responses.  This is confirmed as correct!