SQL Aggregation error and tables


We are having the following issue.

We can connect to the MSSQL database(2019) via a direct connection(Microsoft SQL Server) the problem is we only see 2 service accounts in the database when we aggregate

When we use a third party (DBeaver) tool (using the same account) we can see the 2 tables with the users and details and the entitlements in it.

So I think it is not a rights issue
The tables were created for the solution were users and entitlements are stored in

Any ideas on resolving this?

If it’s not a rights issue, then it might be an incorrect SQL query used in the account aggregation operation. For reference, here are the docs for JDBC connectors.

Came here to make the same suggestion. It’s hard to be faster than @colin_mckibben though!