Connection to SQL DB failing

jakebarr98 — Wed, 16 Aug 2023 12:43:43 GMT

Hi,

I am using Qlik cloud, and a few of my apps pull from a SSMS database.

The connection was created months ago, and I've never had a problem with it. Randomly it has stopped working. I haven't made any changes to the connection but now my apps are failing to load where they're pulling from the SSMS DB and I am receiving the following errors:

ERROR [08001] [Qlik][ODBC] (10380) Unable to establish connection with data source. Missing settings: {[PWD] [UID]}

I have tried entering the username and password to the server and testing connection but it still fails stating the following error:

ERROR [08001] [Qlik][SqlServer] Problem establishing connection to the server

Re: Connection to SQL DB failing

Digvijay_Singh — Wed, 16 Aug 2023 12:53:34 GMT

Probably below link might help, looks like settings changed in the server access recently

https://community.qlik.com/t5/Connectivity-Data-Prep/can-t-connect-to-SQL-database/td-p/1795623

topic Connection to SQL DB failing in Integration, Extension & APIs

Connection to SQL DB failing

Re: Connection to SQL DB failing