About managing access to your SQL Server instance and to company databases

You use the Company Admins / SQL Logins utilities to authorize user access to the SQL Server database, to designate one or more users as a SQL Server administrator, and to assign administrative privileges to certain users for a Sage 100 Contractor company.

You can use Database Administration to set up employees as users in your SQL Server instance, and to designate a user as a company administrator for a specified Sage 100 Contractor company.

A company administrator can always set up additional users and access privileges for those users in a Sage 100 Contractor company for which they have administrative rights.

However, you must use Database Administration to designate a user as a SQL Server system administrator (with a 'sysadmin' role).

Allowing access to the SQL Server database

All Sage 100 Contractor users must be registered in your SQL Server system database, which is separate from your company database.

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.

You use the Add SQL Server Login tab to add users, along with their credentials, to your SQL Server instance. Also, when a company administrator adds a user to the 7-2-2 User List in Sage 100 Contractor, the program automatically creates a SQL Server login if the user ID does not yet exist in the SQL Server database.

IMPORTANT: The migration utility creates logins for all existing users in the version 19.7 company, assigning the same user names and passwords as before.

Prohibiting all access to the SQL Server database

If an employee leaves your company, use the Delete SQL Server Logins tab to remove all access to the SQL Server instance for that employee.

IMPORTANT: After you delete a user's SQL Server login, they can no longer sign in to any Sage 100 Contractorcompany.

If you need to remove a user's access rights to one company, while maintaining their access to other companies, remove the user from the 7-2-2 User List for the company in Sage 100 Contractor.

Assigning administrator privileges for a selected company

Users you designate as company administrators have access rights to the entire Sage 100 Contractor program. In addition, only company administrators can perform the following tasks in Sage 100 Contractor:

Create security groups.
Grant access rights to security groups for windows and certain items within windows.
Grant job-level security to specific users.
Display field properties for a dialog box to set security properties for its various elements or to customize the window in other ways.
Create user names and passwords, and assign user names to security groups in the 7-2-2 User List window.
Set up and modify the General Ledger.
Restrict posting to specific accounting posting periods.

You use the Add Company Administrators tab to designate existing users as administrators for a selected company.

You use the Modify Company Administrators if you need to remove a user's administrator access to a selected company, or to restore administrator access to a user that has had it before.

Note: When you migrate a company, you can select a company administrator from the list of users in the version19.7 company.

SQL Server System administrators ("sysadmin")

Only a user with a sysadmin role in Microsoft SQL Server can administer access to the SQL Server database and assign the sysadmin role to another user. Therefore, it is vital at all times that more than one user has a sysadmin server role. If the principal system administrator should suddenly fall ill, or leave your company, or otherwise be unable to perform their duties, another person with administrative access to the SQL Server database must be able to take over that role.

Note: The person who installs Sage 100 Contractor is automatically assigned a sysadmin role.

You can designate a user as a sysadmin either when you add their SQL Server login or by using the Modify SQL Server Administrators tab.

You also use the Modify SQL Server Administrators tab to remove the sysadmin role for a user.

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.