First, you will setup the user in SQL Server Management Studio (or other third party tool you are using to manage the database).
Add the login mapping the user to your active directory domain. SQL Server accounts are also supported. Here is some additional information about logins versus SQL server accounts. Next, you’ll need to map the login to the new MGR database and give the user three permissions: 1) db_datareader 2) db_datawriter and 3) public.
Now, you’ll go back into the MGR program to the Setup, Maintain User Accounts section. For each user in the drop down at the top of the screen, you’ll map them to their SQL login. Start by selecting the first user, and click on the ‘Map User to SQL Login’ button on the toolbar. This will pop up a window with a list of SQL users – choose the one that matches the current MGR user and click OK. You’ll repeat this for each user in the program.
If you are setting up a brand new user that does not exist in MGR first, you will still add them through SQL first and then when you click the Add New User button in MGR, the select database user pop up will appear for you. Once you click OK, the username and first name fields will be defaulted to the SQL user and you can continue with the user setup.
