topic Re: Not able to connect to SQL server DB From Qliksense HUB in App Development

Not able to connect to SQL server DB From Qliksense HUB

Anonymous — Wed, 30 Aug 2017 19:03:41 GMT

I have a new Qliksense server installation ,

Before that i have used qlik sense desktop and able to connect to Sql DB and i used to pull the reports ,

But now in the Qliksense Server when i am trying to connect to DB using either ODBC or OLEDB , i am not able to establish the connection between the Qliksense hub and Sql DB

I am able to create ODBC in the server and it is tested successfully ,

I used this solution :

Need to disable the standard mode on the QMC > Engines > Central Engine > Edit > Advanced (see Standard mode checkbox at the bottom - untick and restart Engines service).

But no use ,

Please let me know if am missing something or some security issue that i have to change ?

Re: Not able to connect to SQL server DB From Qliksense HUB

barry_stevens — Thu, 31 Aug 2017 02:19:12 GMT

What error do you get?

Are you using windows authentication or SQL server Authentication, does the service account running Qlik have access to the SQL DB?

Re: Not able to connect to SQL server DB From Qliksense HUB

Anonymous — Thu, 31 Aug 2017 14:47:45 GMT

HI Barry ,

Thanks for responding

Yes i am using windows Authentication and service account has access to SQL DB,i have created a ODBC connection using service account also , Both ODBC and OLEDB connection both seems to be failing when i tried to connect to SQL Server , can you please let me know if i miss anything

Re: Not able to connect to SQL server DB From Qliksense HUB

barry_stevens — Thu, 31 Aug 2017 21:59:04 GMT

what error do you get? does the sql server db show an attempted connection? what version of sense?