2 Replies Latest reply: Sep 2, 2016 9:32 AM by Sumanasa R S Kanchana RSS

    Not able to connect with Microsoft OLE DB Provider for SQL Server

    Sumanasa R S Kanchana

      Hi,

       

      I am trying to connect to SQL Server with "Microsoft OLE DB Provider for SQL Server" in Qlik Sense. I have full access on SQL Server that I'm trying to connect to from Qlik Sense. But my OLE DB connection manager on Qlik Sense throws an error saying "Test Failed". I can't make out the cause of error. Could anybody help? Also, if I were to check the Qlik Sense log files for this failure details, which log file should I be looking in?

       

      Thank you,

      Sumanasa