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

[pentaxadmin]

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

[pentaxadmin · Accepted solution]

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"