Qlik Community

Ask a Question

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
ngosz4074
Contributor III
Contributor III

Unable to connect to database

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! 

1 Solution

Accepted Solutions
ngosz4074
Contributor III
Contributor III
Author

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.

View solution in original post

5 Replies
paul_scotchford
Specialist
Specialist

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

Not applicable

Hi Neal,

You would need to install "Qlik Connector Packages"

ODBC Connector

Here is the link for you.

ngosz4074
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

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
Contributor III
Contributor III
Author

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.

View solution in original post