topic Unable to see ALL Databases on the Sql Server in Connectivity & Data Prep

Unable to see ALL Databases on the Sql Server

Thu, 27 Oct 2016 19:16:30 GMT

Hello,

I am able to connect to the sql server from Qlik Sense Enterprise. But after connecting, I see that I dont see ALL the databases..

Is this a Qlik limitation?

I have a desktop version of Qlik Sense and when I access the same server from there, I am able to see all of the databases..

Any help would be much appreciated.

Kind Regards

Simy

kaushiknsolanki — Thu, 27 Oct 2016 19:32:51 GMT

Hi Simy,

Couple of things.

1. Hope you are using the same user from Qlik Sense Server and Desktop.

2. At times as an added security some of the IP's are blocked to have full access,kindly check on that too.

Regards,

Kaushik Solanki

Thu, 27 Oct 2016 19:43:30 GMT

Thanks a lot Kaushik!

I had installed Qlik with a service account and that account had limited access to the server..

I now gave access to that account .. and it works!

Appreciate your quick response

Kind Regards

Simy