Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

OLEDB Sql Server problem with Qlik Sense

Hi,

I have worked for several years with QlikView, ans have some apps working great.

My employer wants to go to Qlik Sense, so I'm learning it.

My first problem is when I try to make a connection in Qlik Sense, the connection fail.

I'm using "Microsoft OLE DB Provider for SQL Server".

In Qlikview with the same configuration and same credentials it's working fine.

The db admin said to me that the logs say that the credentials are not valid.

I can not figure out what is going wrong, does anybody has an idea ?

1 Solution

Accepted Solutions
Highlighted
Contributor III
Contributor III

I solved my problem in a different way : using Qlik ODBC Connector Package

I use same credentials and it created the connection.

(still don't know why OLE DB work in QlikView and not in Qlik Sense)

Thanks for your time.

View solution in original post

12 Replies
Highlighted
Partner
Partner

Are you using Qlik Sense Desktop ?

Which version ?

Highlighted
Contributor III
Contributor III

yes version is november 2017

Highlighted
Master II
Master II

Maybe use

OLE DB Provider for Microsoft Directory Services (32bit) ??

You cannot use Windows Integrated security instead of username and password to test the connection?

Highlighted
Partner
Partner

did you try using "Windows integrated security" ?

Highlighted
Contributor III
Contributor III

no because I can not do that, i must use username / password.

I tried all providers including 32bit without success

Highlighted
Partner
Partner

let's try using the same driver and credentials with Qlikview Desktop on the same computer.

Highlighted
Creator
Creator

Hi have you tried just Qlik embedded drivers.

Step 1 create new app

Step 2 select the 'Add data from files and other sources' button

Step 3 select Microsoft Sql Server (as in image)

Step 4 put connection details in.  You will need the user to have at least read access to the database you connect to

sqlimgqlik.PNG

Highlighted
Contributor III
Contributor III

yes it s working this way.

but I would like to have a connection in script mode.

To explain my needs :

I work for a SaaS application editor, all  QV applications are accessed through this application (using web tickets).

I also have QV applications for generating QVDs.

Now I installed Qlik Sense server, and I try to make apps with Qlik Sense Desktop, for distribute them in the same way.

Highlighted
Creator
Creator

1. Try to use the password to access database using SSMS  -Does this work.

If so then the account is correct.

2. Is account on a domain.  If so try adding domain to the account login name.