Connection to SQL server 2012

[#1]

Hello All,

Could you please help on this issue.

We are able to see a preview of the data on our SQL database but unfortunately, we are unable to load the data to qlikview, error message is as below:

SQL##f - SqlState: 28000, ErrorCode: 18456, ErrorMsg: [Microsoft][ODBC SQL Server Driver][SQL Server]Échec de l'ouverture de session de l'utilisateur ''.

ODBC CONNECT TO XXXXX

Thanks.

Kind Regards,

Hasvine

[Gysbert_Wassenaar]

Whatever the problem is, it's not Qlikview, but the ODBC driver that fails. Perhaps you're trying to load data that the ODBC driver does not support. You can try to isolate the field. Or you can try an OLEDB connection.