Unable to connect to database

[ngosz4074]

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! 

[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

[#3]

Hi Neal,

You would need to install "Qlik Connector Packages"

ODBC Connector

Here is the link for you.

[ngosz4074]

Thanks for the information.  Upon the install, I'm running into a Error 2738 - Could not access custom VBScript, which appears to be a Microsoft issue.  I'll try again once I fix this.

[ngosz4074]

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.

[ngosz4074 · Accepted solution]

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.