MSFT OLE DB Provider for SQL Server/SQL Server Native Client 11 Connectors

pentaxadmin — Tue, 26 Dec 2017 21:25:48 GMT

Dear Community:

I am having issues to connect to SQL Server via Qlik Sense. I read threads from other users who experienced similar issue, but was not able to establish connection. What bothers me is that I was able to test connection as referenced in https://blogs.msdn.microsoft.com/farukcelik/2007/12/31/basics-first-udl-test/ and had no problems, but Qlik refuses to establish the same connection with identical credentials. I even installed SQL Server Native Client 11 on Qlik Server (as suggested by others) - now it shows up in the list of connectors, but it didn't help.

Thanks for your input.

Branislav

Re: MSFT OLE DB Provider for SQL Server/SQL Server Native Client 11 Connectors

pentaxadmin — Thu, 04 Jan 2018 23:01:19 GMT

I deleted my original reply to this thread by accident, but I was able to fix the issue by switching QS Services from QSAdmin to UserName

I found a similar thread with the same issue that helped me.

Unable to connect SQL Server - "Username not found error"

topic MSFT OLE DB Provider for SQL Server/SQL Server Native Client 11 Connectors in Management & Governance

MSFT OLE DB Provider for SQL Server/SQL Server Native Client 11 Connectors

Re: MSFT OLE DB Provider for SQL Server/SQL Server Native Client 11 Connectors