Qlik Community

Third-Party Qlik Jobs

Area for people to learn more about current Qlik related job postings.

Highlighted
sashokku
Contributor II

Pulling data from MS SQL server

Unable to pull data from MS SQL server onto Qlik (Enterprise Edition Nov 2017).  Steps that I followed, Data Load Editor-> Data Source-> Tested connection-> Success. Select data, I am able to see/pull data from other databases. But, I am unable to pull the data from database that I am looking for. Is there any security settings that I am missing in SQL server or Qlik. Help me out.  

 

q1.JPG

Labels (2)
4 Replies
janvlasveld
New Contributor II

Re: Pulling data from MS SQL server

Got  the same  problem. Please help.

skamath1_metlif
Contributor II

Re: Pulling data from MS SQL server

the user account may not have access to the database.  check with the SQL dba to get access?  Did you try any other tools like SSMS to see if the same user account can access?

sashokku
Contributor II

Re: Pulling data from MS SQL server

Thanks for the response. Tried accessing the database, User have access to the tables.

Within Qliksense, with the same user name was able to pull data from other databases too where the user don't have access for those databases. It was weird.
sashokku
Contributor II

Re: Pulling data from MS SQL server

Any luck @janvlasveld ?
Community Browser