Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Community is experiencing an influx of spam. As we work toward a solution, please use the 'Notify Moderator' option on the ellipsis menu to flag inappropriate posts.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

No In-Database data received

Vernon
7 - Meteor

Hi everyone:

 

Encountering an issue with a particular individual but not with anybody else on the team.

 

User is trying to use IN-DB took to just grab records from a SQL Server.

He is having issues with every table on the SQL Server (There are records in every table).

 

He is also able to browse the tables using the visual query builder and see the variables.

 

This is a simple Select * query and then top 100.

 

Any thoughts on how we can resolve this issue?

 

Vernon_0-1610120537433.png

 

2 REPLIES 2
Ladarthure
14 - Magnetar
14 - Magnetar

Hi @Vernon,

 

it might be linked to the user rights to see data in the table, have you tried those user/pwd on another software?

Vernon
7 - Meteor

Hi @Ladarthure 

 

Thanks for your response. Yes, we have tried it on SSMS and it works fine.

 

User/pwd is based in Windows AD

Labels