CAUTION: Changing default permissions or sharing on other files and folders, could result in conflicts, unwanted access to critical files, data loss, and critical task failures. The critical tasks include backups, nightly maintenance, archiving, and database updates.

File Shares

Sage 100 Contractor requires specific file shares for the user and critical Database Administration tasks. The program creates these shares automatically during installation and when it creates or restores a database from a backup.

Default folder shares

Common (\Sage 100Con\Common\): Share with Full Control permissions for the Administrators group.
 NOTE: The share name must be Sage100Contractor. All subfolders within the Common folder inherit their permissions and rights from the Common folder. 

Files (Company\(database name)\Files\): Share with Full Control permission for the Administrators group.
 NOTE: The share name must be the same as the company's database folder. 

Don’t share the following folders

Sage100Con

Backup (\Sage 100Con\Backup\)

Downloads (\Sage 100Con\Downloads\)

Logs (\Sage 100Con\Logs\)

Settings (\Sage 100Con\Settings\)

SupportScripts (\Sage 100Con\SupportScripts\)

Temp (hidden file) (\Sage 100Con\Temp\)

File permissions

 CAUTION: 
• Don’t change permissions for any folders and subfolders mentioned below.
• All subfolders inherit their permissions and rights from the parent folder.
• Software requires Full Control user access to some folders. Don't attach sensitive or personal files to the database records. 

Sage100Con folder: Full Control permissions to the SYSTEM account, user account used for installation, Administrators group, and Windows Local Service account for AADAP (Azure Active Directory Application Proxy) if installed.

Backup: The program uses this folder to create and restore backups.

Common: All Sage users need access to this folder. The Authenticated Users group, Administrators group, and Windows System account have Full Control permissions.

Company: This folder contains your SQL company database with permissions for SQL Server to access data and administrators to perform database management. The following users and accounts have Full Control permissions:

• SYSTEM account
• User account used for installation
• Administrators group
• SQL service account (MSSQL$[instance name])
• Windows Local Service account for AADAP

Individual company folder (Company\(database name)\: These folders and their content have specific permissions for SQL Server, Sage 100 Contractor, and Database Administration.

Files (Company\(database name)\Files\): This folder inherits its permissions from the Company folder. The following users and groups must have Full Control permissions to this folder and its content.

• Sage users or the user group that includes Sage users needing access to the company database
• The Administrators group
• The Windows System account (NT Authority\System)

Downloads: Includes SQL Server installation download with access to the Administrators group and Windows System account.

Logs: It includes the log and setting files for Database Administration and other services with access to the Administrators group.

Settings: it includes configuration files for the SQL Server and Database Administration. The Administrators group, Windows System account, and Windows Local Service account have access.

Temp: Hidden folder used by SQL Server and Database Administration to create and restore backups.

 NOTE: From the Toolbox, Server Tools menu in Database Administration, you can Restore permissions for the Sage 100 Contractor file system. Running this utility resets to default file permissions but doesn't change the file sharing.