I am trying to use AD/Windows groups with Workflow manager.
Ive got a SQL Server database with a user/schema called "workflow". That works fine.
However, unless Im mistaken, when I map the AD groups to the workflow database I get errors when I try to execute any queries (eg look up all jobs in WMX itself).
Turns out the query that is trying to execute is "select * from JTX_JOBS" where I would expect "select * from workflow.JTX_JOBS". So its not appending the schema name to the query.
Now, you cant specify a default schema with an AD group so I think the only choice is to use a DBO schema (as this is the default if there is no default).
Or am I wrong?