Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
santho_ak
Partner - Creator III
Partner - Creator III

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 (1)
  • SQL

4 Replies
janvlasveld
Partner - Contributor II
Partner - Contributor II

Got  the same  problem. Please help.

skamath1
Creator III
Creator III

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?

santho_ak
Partner - Creator III
Partner - Creator III
Author

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.
santho_ak
Partner - Creator III
Partner - Creator III
Author

Any luck @janvlasveld ?