To create an SQL-authenticated user

1. Connect to Database Administration for Sage 100 Contractor.
2. Click Company Admins/SQL Logins, then Add SQL Server Login.
3. From the Authentication picklist, select SQL Server Authentication.
4. Type the SQL user name in the Login field.
5. Type the desired password in the Password field.
6. Check the box for Add as a member of the sysadmin server role.
    NOTE: Select this option when you want to grant the user access to Sage 100 Contractor Database Administration.  
7. Click Create SQL Login.
8. Add this new user to the company databases by clicking Company Admins/SQL Logins and Add Company Admins.
9. Connect to Sage 100 Contractor by selecting SQL Server Authentication in the Connect to SQL Server window.

To create a Windows authenticated User

1. Connect to Database Administration for Sage 100 Contractor.
2. Click Company Admins/SQL Logins and Add SQL Server Login.
3. Select Windows Authentication in the Authentication picklist.
4. In the Login field, type the Windows authenticated user name [Domain name\username].
5. Skip the Password field.
6. Check the box for Add as a member of the sysadmin server role.
    NOTE: Select this option when you want to grant the user access to Sage 100 Contractor Database Administration. 
7. Click Create SQL Login.
8. Add the new user to the company databases by clicking Company Admins/SQL Logins and Add Company Admins.
9. Connect to Sage 100 Contractor by selecting Windows Authentication on the Connect to SQL Server window.

To manually add an existing SQL or Windows authenticated user

1. Open the Sage 100 Contractor company with Administrator rights.
2. Open menu 7-2-2 User List.
3. On a blank row, in the User Name column, enter one of the following:
   • The Windows authenticated user name (for example, domainname\Username)
      NOTE: For Windows authenticated users, leave the Password field blank  
   • The SQL authenticated user name
      NOTE: For SQL-authenticated users, enter a password in the Password field
4. Assign at least one security group to the user in the Security Group field.
5. Enter Yes in the Company Admin field if the user is a company Administrator.
6. Click File, Save.

To edit or change an SQL-authenticated user password

1. Open the Sage 100 Contractor company with Administrator rights.
2. Open menu 7-2-2 User List.
3. Click the User Name row of the user.
4. Click the Password cell and press the delete (del) key on the computer keyboard.
5. Click the Password cell again and enter a new password.
6. Press Enter on the computer keyboard.
7. Click File, Save.