topic SQL server connection credentials in Connectivity & Data Prep

SQL server connection credentials

rossmar — Thu, 22 Sep 2022 06:17:19 GMT

Hello,

My apps suddenly stopped auto refreshing on scheduled time. Upon checking, i realized it has something to do with the connection. Seems like the credentials are not working. I tried to re-entered the same credentials i have been using for the last 8 months but it's giving me the error "Name or service not known"

I didnt change a thing on the server side in terms of access and policies.

Anyone knows what to do?

Thank You

Re: SQL server connection credentials

NadiaB — Tue, 27 Sep 2022 20:35:33 GMT

Hi @rossmar

Is this Qlik Sense on prem or Cloud(SAAS)?

Can you attempt to use the same credentials from another client (SQL Management studio), does it work?

Can you also double check the server name is correct and didn't change?

It also looks like there was an issue last Thursday :

https://community.qlik.com/t5/Connectivity-Data-Prep/QlikSense-Sudden-Connectivity-issues-to-on-Prem-SQL-quot-Name-or/td-p/1983918

Hope it helps.