5 Replies Latest reply: Jan 29, 2016 12:08 PM by Neal Gosz RSS

    Unable to connect to database

    Neal Gosz

      Hello,

       

      We're using QlikSense and have an enterprise license.  We're able to connect to Excel files and QVDs.  However, we're unable to connect to SQL Server using OLE DB.  Every time we try to connect, we get a general "Connection Failed" message and are unable to load our databases.  We've tried connecting from a server location or by typing in the address. 

       

      Can someone provide assistance on the steps we need to connect to SQL Server and view our list of databases?

       

      A second question - there's a 50.0 GB limit on table files, are we able to bring in larger QVDs?

       

      Thanks in advance! 

        • Re: Unable to connect to database
          Paul Scotchford

          Hi Neal

           

          Firstly check the SQL Logs to ensure a connection is being made from your Sense server, then check your SQL server connection security to ensure the QlikSense services username has access to your SQLServer instance (your DBA should be able to help)

           

          I would guess the issue is at the SQL Sever side, the logs should pinpoint the issue, more often than not it's SQL Server security.

           

          Failing that , then firewalls etc , ports and so on, just throwing ideas about as I dont know your config

           

           

          cheers

          Paul

          • Re: Unable to connect to database
            Sai Kumar

            Hi Neal,

             

            You would need to install "Qlik Connector Packages"

            ODBC Connector

            Here is the link for you.

            • Re: Unable to connect to database
              Neal Gosz

              What was happening was we had the ODBC drivers installed for the wrong version of SQL Server and not on the QlikSense server.  We installed the ODBC SQL Server driver for the correct version of SQL Server and we're able to connect saying we don't have access to the data source, so we'll check the SQL Server logs.

               

              Once we get a resolution, we'll update.

                • Re: Unable to connect to database
                  Neal Gosz

                  Here's the resolution.  In the initial install, the service account was not tied to the services. When installing QlikSense on the server, make sure the QS service account is the account doing the install to make sure all of the services are working properly. 

                   

                  We had to do an uninstall / reinstall of QlikSense and then we were able to connect to the databases.