topic Re: can't connect to SQL database in Connectivity & Data Prep

can't connect to SQL database

Marych — Tue, 30 Mar 2021 10:46:06 GMT

Hello,

I want to create a connection Microsoft SQL Server

but i get an error message :

Error message: Please check the values for Username‚ Password‚ Host and other properties. Description: Client unable to establish connection

ERROR [28000] [Qlik][ODBC] (11570) Required credential settings missing: {[PWD]}.

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

Re: can't connect to SQL database

Or — Tue, 30 Mar 2021 11:04:05 GMT

It sounds like you didn't enter the password...?

In the connection popup, make sure you scroll down and fill all the necessary fields.

Re: can't connect to SQL database

Marych — Tue, 30 Mar 2021 11:08:07 GMT

well, i don't have a password, therefore i didn't enter any and i filled all of the fields, at least i think so..

Re: can't connect to SQL database

Or — Tue, 30 Mar 2021 11:12:44 GMT

My understanding is that a password is required unless you use single sign on for your SQL Server, in which case you should select that setting. However, I'm not an expert on SQL Server security requirements, so perhaps this is not the case.

Re: can't connect to SQL database

PadmaPriya — Wed, 07 Apr 2021 04:32:55 GMT

Hello @Marych ,

Are you using SA Account or Windows authentication? Do you have DB_owner and Sysadmin access?

Please test the connectivity from Qlik Application hosted server to Database following the below link:

https://support.qlik.com/articles/000117572

For the similar issue please find below article and let us know the feedback if this is fixing the problem:

https://support.qlik.com/articles/000058512

Thanks,

Padma Priya

Senior Technical Support Engineer-Qlik Support