Solved: OLEDB Sql Server problem with Qlik Sense - Qlik Community

Anonymous · ‎2017-12-11

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 ?

Anonymous · ‎2017-12-21

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.

agigliotti · ‎2017-12-11

Are you using Qlik Sense Desktop ?

Which version ?

Anonymous · ‎2017-12-11

yes version is november 2017

MK9885 · ‎2017-12-11

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?

agigliotti · ‎2017-12-11

did you try using "Windows integrated security" ?

Anonymous · ‎2017-12-11

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

I tried all providers including 32bit without success

agigliotti · ‎2017-12-11

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

darrell_tobin · ‎2017-12-11

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

Anonymous · ‎2017-12-12

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.

darrell_tobin · ‎2017-12-12

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.