trevor_hart-eagle-co-nz-esridist

WMX and AD Groups (or Windows Groups)

Discussion created by trevor_hart-eagle-co-nz-esridist on Mar 4, 2012
Latest reply on May 14, 2012 by tbello-esristaff
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?

Outcomes