Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
jakebarr98
Contributor
Contributor
‎2023-08-16 08:43 AM

Connection to SQL DB failing

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

Labels (6)
738 Views
0 Likes
1 Reply
Digvijay_Singh
MVP
MVP
‎2023-08-16 08:53 AM

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

 

729 Views
0 Likes