topic Re: Not able to connect with Microsoft OLE DB Provider for SQL Server in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/Not-able-to-connect-with-Microsoft-OLE-DB-Provider-for-SQL/m-p/1890599#M10197 <P>Did you ever figure this our? I'm having the same issue with an Oracle OLE DB connection and not sure what to do!</P> Tue, 08 Feb 2022 19:14:37 GMT nategreen 2022-02-08T19:14:37Z Not able to connect with Microsoft OLE DB Provider for SQL Server https://community.qlik.com/t5/Connectivity-Data-Prep/Not-able-to-connect-with-Microsoft-OLE-DB-Provider-for-SQL/m-p/1123457#M1887 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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?</P><P></P><P>Thank you,</P><P>Sumanasa</P></BODY></HTML> Wed, 31 Aug 2016 14:16:42 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Not-able-to-connect-with-Microsoft-OLE-DB-Provider-for-SQL/m-p/1123457#M1887 2016-08-31T14:16:42Z Re: Not able to connect with Microsoft OLE DB Provider for SQL Server https://community.qlik.com/t5/Connectivity-Data-Prep/Not-able-to-connect-with-Microsoft-OLE-DB-Provider-for-SQL/m-p/1123458#M1888 <HTML><HEAD></HEAD><BODY><P>Is the driver installed on the machine were Qlik Sense is running?</P><P>Can you connect to the SQL Server from the machine where Qlik Sense is running?</P><P>Are you using the correct credentials from Qlik Sense?</P></BODY></HTML> Fri, 02 Sep 2016 10:59:41 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Not-able-to-connect-with-Microsoft-OLE-DB-Provider-for-SQL/m-p/1123458#M1888 Gysbert_Wassenaar 2016-09-02T10:59:41Z Re: Not able to connect with Microsoft OLE DB Provider for SQL Server https://community.qlik.com/t5/Connectivity-Data-Prep/Not-able-to-connect-with-Microsoft-OLE-DB-Provider-for-SQL/m-p/1123459#M1889 <HTML><HEAD></HEAD><BODY><P>Yes driver is installed. I also tested connectivity to DB server from OLE DB provider using udl file (as in this link: <A href="https://blogs.msdn.microsoft.com/farukcelik/2007/12/31/basics-first-udl-test/" target="_blank" title="https://blogs.msdn.microsoft.com/farukcelik/2007/12/31/basics-first-udl-test/">Basics first : "UDL Test" – A Technical Evangelist's Guide to "Microsoft Azure" Galaxy</A>). Its connecting ok when I try through udl on qlik server. But its not connecting at all from qlik sense hub.</P></BODY></HTML> Fri, 02 Sep 2016 13:32:42 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Not-able-to-connect-with-Microsoft-OLE-DB-Provider-for-SQL/m-p/1123459#M1889 2016-09-02T13:32:42Z Re: Not able to connect with Microsoft OLE DB Provider for SQL Server https://community.qlik.com/t5/Connectivity-Data-Prep/Not-able-to-connect-with-Microsoft-OLE-DB-Provider-for-SQL/m-p/1890599#M10197 <P>Did you ever figure this our? I'm having the same issue with an Oracle OLE DB connection and not sure what to do!</P> Tue, 08 Feb 2022 19:14:37 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Not-able-to-connect-with-Microsoft-OLE-DB-Provider-for-SQL/m-p/1890599#M10197 nategreen 2022-02-08T19:14:37Z