Windows integrated security is not working for SQL Server

[#1]

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.

[Gysbert_Wassenaar · Accepted solution]

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

[JonnyPoole · Accepted solution]

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.

[Michael_Tarallo]

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

[#5]

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

[Rakesh_HB · Accepted solution]

For those who are checking this blog in 2022, the requirements are mentioned here:

OLE DB data connection settings 

• Windows integrated security: With this option, you use the existing Windows credentials of the user running the Qlik Sense service.

[varaprasad0816]

Hi Michael,

I would like to know why Windows Integrated Security Connection not making connection string in Qliksense with given Data Source Name (XYZ) which I can able to access from MS SQL Server Management Studio.
But getting Test Unsuccessful while connecting from different providers with given data source name.
please help me out on this.
I would like to know more details on this issue

Note : I have checked in my SSMS that the properties are same as your above mentioned screenshots, The ID that is authorized to use MSQL.

Please reply me back

[varaprasad0816]

Hi,

I would like to know why Windows Integrated Security Connection not making connection string in Qliksense with given Data Source Name (XYZ) which I can able to access from MS SQL Server Management Studio.
But getting Test Unsuccessful while connecting from different providers with given data source name.
please help me out on this.
I would like to know more details on this issue

Please reply me back

[varaprasad0816]

Hi,

I would like to know why Windows Integrated Security Connection not making connection string in Qliksense with given Data Source Name (XYZ) which I can able to access from MS SQL Server Management Studio.
But getting Test Unsuccessful while connecting from different providers with given data source name.
please help me out on this.
I would like to know more details on this issue

Please reply me back

[varaprasad0816]

Hi,

I would like to know why Windows Integrated Security Connection not making connection string in Qliksense with given Data Source Name (XYZ) which I can able to access from MS SQL Server Management Studio.
But getting Test Unsuccessful while connecting from different providers with given data source name.
please help me out on this.
I would like to know more details on this issue

Please reply me back