topic ODBC Connectivity Issue in Connectivity & Data Prep

ODBC Connectivity Issue

RickyK — Fri, 11 Nov 2022 02:49:41 GMT

Hello All,

Greetings!!

We are facing some ODBC connectivity issues in QlikView extractor files

Below the error msg:

Error: Connector connect error: SQL##f - SqlState: 08001, ErrorCode: 53, ErrorMsg: [Microsoft][ODBC Driver 17 for SQL Server]Named Pipes Provider: Could not open a connection to SQL Server [53].

Most of Qlik applications are getting failed with this error even we have access to the DB server.

kindly help us on this issue.Thanks!

Ricky

Re: ODBC Connectivity Issue

marcus_sommer — Fri, 11 Nov 2022 15:26:10 GMT

It's not directly related to Qlik else to your environment. Take this as a starting point for further investigations:

SQL server error 53 sqlstate 08001 - How we fix it (bobcares.com)

- Marcus

Re: ODBC Connectivity Issue

RickyK — Fri, 11 Nov 2022 15:51:57 GMT

Hi Marcus,

Thanks for your reply!

have tried the above link to troubleshoot the issue.

found that Microsoft SQL Server Native Client Version also getting fail.

It seems to be another instance of illumio blocking the connection.

I think we need to whitelist the server name that is being used to connect to DB server if it is indeed illumio blocking.

If yes, where do I whitelist the server name? Thanks!

RickyK

Re: ODBC Connectivity Issue

marcus_sommer — Fri, 11 Nov 2022 15:58:54 GMT

I don't know illumio but I assume that there is also a community and/or FAQ area in which its more likely to find the appropriate hints how to config this kind of issue.

- Marcus

Re: ODBC Connectivity Issue

RickyK — Sat, 12 Nov 2022 01:09:24 GMT

Ok, thanks Marcus,

I'm trying to find the solution for this