1 Reply Latest reply: May 16, 2018 11:19 AM by Andy Weir RSS

    Not able to connect to Microsoft SQL 2012 database installed on a remote desktop

    Sudhakar Singh

      Hi All,

       

      I am using Qlik Sense Desktop on my windows 10 machine and need to integrated it with Microsoft SQL 2012 installed on remote server (with operating system as Microsoft Server 2012). I have the IP address of the remote server, login credentials of remote desktop, Microsoft SQL Server 2012, Database & Table names.

       

      Using OLE DB, when I test connection, it's successful but Load data is not loading database i.e. database name doesn't appear in the drop down.

       

      Would appreciate if someone can point out the mistake?

       

      Thanks,

      Sudhakr