ERROR: Unable to open source queries because Query 'XXX' is not found in the database. – ADO Field is nothing

(0) Share

Report

Posted on by Community Member

The users are both pointed to the correct Integration Manager database however, one user is able to run the integration without error and the other one received the error

ERROR: Unable to open source queries because Query 'XXX' is not found in the database. – ADO Field is nothing

It is an Advanced ODBC source and there is a SQL query involved. It is a Terminal Server. Could this possibly be a permissions error? If so, what should we check?

Thanks!

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Jonathan Fear Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

This sure does sound like it could be SQL permissions causing this issue. If other users are able to run the same integration successfully I would look into what the difference is in SQL between the users.

Was this reply helpful? Yes No