File Shares

Specific files are shared in the Sage 100 Contractor file system (Sage100Con) to allow the software to access these files and for Database Administration to perform certain critical tasks. These shares are automatically created when the software is installed and when a new database is created or restored from backup. Only the files designated to be shared in the list below should be shared. Sharing files other than those designated to be shared can result in sharing conflicts, unwanted access to critical files, and possible loss of data.

• Sage100Con - Do not share
  • Backup - Do not share
  • Common – this folder is fully shared with full share permissions to the Administrators group. The share name must be "Sage100Contractor".
    • All folders under the Common folder- these folders inherit the same sharing properties as the Common folder
  • Company - Do not share
    • Company\(database name) - Do not share
      • Company\(database name)\Files\ - this folder is fully shared with full share permissions to the Administrators group. The share name must be the same as the database folder for that company.
  • Downloads - Do not share
  • Logs - Do not share
  • Settings - Do not share
  • SupportScripts (if present) - Do not share
  • Temp (hidden file) – Do not share

File Permissions

For the software and the tasks in Database Administration to properly function, Sage assigns a specific set of permissions to the Sage 100 Contractor file system (Sage100Con) during the initial installation of the software and when new databases are created (including archives) or restored from backup. Changing these permissions can fail in critical functions such as backups, nightly maintenance, archiving, and database updates. Please note that as the software requires some folders to have broad permissions to properly function, it is not advised to store or attach files of a sensitive or personal nature to records in your database.

Here are the guidelines for the file permissions for the Sage 100 Contractor file system that will allow the software and the Database Administration tools to function properly:

• Sage100Con folder – Do not change. This folder must have full permissions granted to the SYSTEM service account, the Windows user who installed the software, the Administrators group, and the Windows Local Service account (if AADAP for mobile is installed)
  • Backup – Do not change. Inherits permissions from the parent Sage100Con folder
  • Common – Do not change. This folder must be accessible to all Sage users. This folder must have full permissions granted to the Authenticated Users group, the Administrators group, and the Windows System account
    • Folder and subfolders inside the Common folder – Do not change. These folders inherit permissions from the Common folder and must also be accessible to all Sage users.
  • Company – Do not change. This folder contains your SQL company databases. It has very specific permissions set to allow the SQL Server to access the data and for Administrators to perform maintenance and management functions with the databases in Database Administration. This folder must have full permissions granted to the SYSTEM service account, the Windows user who installed the software, the Administrators group, the SQL service account (MSSQL$[instance name]), and the Windows Local Service account (if AADAP for mobile is installed).
    • Individual company folders inside the main “Company” folder – Do not change. These folders and the files inside have specific permissions set to allow SQL Server, Sage 100 Contractor, and Database Administration to properly access and manage the databases. These folders inherit the same permissions from the parent Company folder.
      • “Files” folder inside each company database folder – Do not change. The permissions are the same as the Common folder as the contents must be accessible to all Sage users. If for some reason you need to change the permissions on this folder and the files and folders within, you must ensure that the following users and groups have full permissions (full control):
        • Users and/or user groups that will be accessing this company database in the software
        • The Administrators group
        • The Windows System account (NT Authority\System)
  • Downloads – ­Do not change. This file contains the installer downloads SQL Server and should only be accessible to the Administrators group and the Windows System account.
  • Logs – Not recommended they be changed. This folder contains the various log files and log settings for Database Administration and other services for the software. Typically, only server administrators would need to see the logs, but they have the same permissions as the Common folder as they do not contain sensitive information.
  • Settings – Do not change. This folder contains the configuration files for the SQL Server and Database Administration and should only be accessible by server administrators, the Windows System account, and the Windows Local Service account (if AADAP for mobile is installed).
  • Temp – Do not change. This is a hidden file and is used by SQL Server and Database Administration to create and restore backups.

Important Note: In Database Administration, under Toolbox > Server Tools, there is an option to “Restore permissions for the Sage 100 Contractor file system”. Running this utility will reset file permissions to the settings described above. This utility will not change file sharing, only file permissions.