Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

bujnakbranislav
Contributor

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

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

1 Solution

Accepted Solutions
bujnakbranislav
Contributor

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

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"

1 Reply
bujnakbranislav
Contributor

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

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"

Community Browser