topic How to create new connection from new database (SQL or OLEDB ) with our windows credentials in Qliksense (Windows Credentials are not working)) in Connectivity & Data Prep

How to create new connection from new database (SQL or OLEDB ) with our windows credentials in Qliksense (Windows Credentials are not working))

varaprasad0816 — Mon, 27 Nov 2023 15:59:44 GMT

Hi Everyone,
Have a good day !!

Would like to know the process :

Need some help on how to create new connection from new database (SQL or OLEDB ) with our windows credentials.
currently, we are creating connection string from Specific User Name and Password (Unique FID with EPV password), but here Windows integrated security credentials are not working.

But my manager would like to know the process on windows credentials for connection string in Qliksense (I know that we need server name, database name, Windows User ID and Password >>> but these are not working as Test Connection is getting unsuccessful )

Please help me on this request with the process how these windows credentials can be work to get the connection string.

Please find attached screenshots for your reference.

Regards,

Vara

Re: How to create new connection from new database (SQL or OLEDB ) with our windows ...

Ray_Strother — Mon, 27 Nov 2023 18:21:29 GMT

Hello Vara,

Please review the links below and confirm the configuration. Whatever the account used when configuring the connection,it needs to have permissions granted inside the database.

Article links:

1. Data connections

https://help.qlik.com/en-US/sense-admin/November2023/Subsystems/DeployAdministerQSE/Content/Sense_DeployAdminister/QSEoW/Administer_QSEoW/Managing_QSEoW/data-connections-overview.htm

2. Connecting to your data - Qlik Sense

https://www.youtube.com/watch?v=SUN4P9FQwhQ

3. Creating a connection and selecting data

https://help.qlik.com/en-US/connectors/Subsystems/Integrated_Web_Connectors_help/Content/Connectors_QWC_BuiltIn/Introduction/Creating-a-connection.htm

Re: How to create new connection from new database (SQL or OLEDB ) with our windows credentials in Qliksense (Windows Credentials are not working))

varaprasad0816 — Wed, 29 Nov 2023 21:52:32 GMT

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 connection from different providers with given data source name.
please help me out on this.
I would like to know more details on this issue