Adding a SQL Server Login

When you or another company administrator adds employees as users in Sage 100 Contractor, you authorize them to use your SQL Server database by:

Adding their user names to your SQL Server instance.
Selecting a method to authenticate their user names and passwords.
Defining their passwords (depending on the authentication method you select).
Optionally, assigning a system administrator role to a user.

Although you can use SQL Server Management Studio to add SQL Server users, Database Administration for Sage 100 Contractor provides a much simpler way to set up SQL Server login credentials.

To add a SQL Server login for a user

Click Company admins / SQL Logins > Add SQL Server Login.
From the Authentication list, select an authentication method.
- If you select Windows Authentication, in the User name box, type the Windows user name for this user.
  
  Note: You must enter a user name that is valid for the Windows domain or workgroup that hosts the SQL Server instance.
  
  When the user signs into the company with their Windows user name, Sage 100 Contractor authenticates the user name and password they entered when signing into Windows.
- If you select SQL Server Authentication, type the SQL Server login and password to use to authenticate this user when they sign into the company.
If this user should also be a SQL Server administrator, select the Add as a member of 'sysadmin' server role check box.
Click [Create SQL Login].

After adding a SQL Server login

In Sage 100 Contractor, add the user to the 7-2-2 User List.
If the user requires administrative privileges in Sage 100 Contractor, add them as a company administrator using the Database Administration tool.

More resources

For additional online resources for Sage 100 Contractor products, visit the Sage Customer Portal. Use the portal to access the knowledgebase, chat online with customer support, or enter a customer support ticket.

For additional training on Sage products, visit Sage University.