How do AllMax Applications Authenticate to SQL Server

AllMax applications utilize Windows Authentication to authenticate to SQL Server. To do so, the SAMAccountName of the authenticated user is passed to SQL to apply security. Most users need only Public access at the instance level and read/write access to each AllMax database. If a user is an admin in the AllMax application, they also need the dbcreator Server Role in SQL Server. Database deletion is not done through the AllMax applications, so the ability to delete a database is not needed. 

 Users can be added to SQL Server security individually, but we recommend using a Group for ease of maintenance.