Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

manojkulkarni
Valued Contributor II

QlikSense connectivity to SQL Server 2014

Hi Friends,

I am trying to connect SQL Server 2014 from QlikSense Desktop v 2.1.1. I am able to make connection, but database name is not getting listed. Only System Databases are listed. Same I was able to do with 2008 Server.

What could be the issue ? Please suggest, it is very urgent.

4 Replies
awhitfield
Esteemed Contributor

Re: QlikSense connectivity to SQL Server 2014

How are you trying to connect?

Andy

manojkulkarni
Valued Contributor II

Re: QlikSense connectivity to SQL Server 2014

Using OLE DB Connection String with Windows Authetication.

awhitfield
Esteemed Contributor

Re: QlikSense connectivity to SQL Server 2014

Do you have adequate permission on the user DBs?

manojkulkarni
Valued Contributor II

Re: QlikSense connectivity to SQL Server 2014

Yes. I could do all the operations in Query Manager.