OLEDB Sql Server problem with Qlik Sense

[Anonymous]

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 ?

[darrell_tobin]

SSMS = sql server management studio

app used to query sql server databses

[Anonymous]

thanks for your answers, but it still not working...

work with SSMS

work with Qlikview

I don't understand what is going wrong...

[Anonymous · Accepted solution]

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.