Creating SQL or Windows authenticated users and Company Administrators
Description
Cause
Resolution

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.

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.

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.
[BCB:154:Chat 100 Contractor US:ECB]

 

 

 

Steps to duplicate
Related Solutions

How to reset SQL-authenticated user password for Sage 100 Contractor