How to use Adminstudio Enterprise Server (AES) or Workflow Manager (WFM) to manage users for Adminstudio without adding all the users to the SQL Database.
You may want to use AES\WFM as a central point to manage users for Adminstudio. This eliminates the need to manage the users from the SQL Database\Server. The main configuration that is needed for this is to use SQL Server Authentication when running the config.exe tool to setup AES\WFM. This ties the connection to SQL to a single SQL account. This will be the account used by AES\WFM to connect to SQL Server. This account will need to have access to the SQL server and database. Do not use Windows Authentication when configuring with the Config.exe tool.
Once the above is done, Adminstudio may use the Enterprise Tab to connect to the catalog and Authenticate based on Users Managed by AES\WFM.
Here is a KB that may help resolve a possible problem when using Windows Authentication.