1. Architectural summary

Sage 100 Contractor uses traditional client/server architecture, which enables multiple people to use the same accounting data from multiple computers.

The Sage 100 Contractor application runs most business processing on client machines, known as workstations.

The Database Administration application performs all server functions, such as data backups and restoration, on the server.

All data is stored in SQL databases and file shares, which are located on the server.

For a single-user office, you can install Sage 100 Contractor and Database Administration on a single machine.

2. Server requirements

Sage recommends that your server is a machine dedicated to Sage 100 Contractor. (A new computer that can perform this function can cost you less than USD $1,000.)

Avoid changing the server environment. Sage 100 Contractor is tested against basic operating system (OS) installations. Many seemingly harmless changes to the server can cause Sage 100 Contractor or some of its advanced features to malfunction.

Server hardware requirements

Server software requirements

* SQL Server 2014 is not supported on Windows Server 2022.

3. Workstation requirements [HIDDEN]

Workstation hardware requirements

Workstation software requirements

3. Workstation requirements [modified in committee]

Workstation hardware requirements

Workstation software requirements

4. Additional considerations

Outbound email

Users can set up Sage 100 Contractor to send emails automatically. Users can also schedule emails to be sent automatically.

Most email providers are constantly improving security measures, specifically to prevent unattended or automated emails. Often, these improvements interfere with the email capabilities of Sage 100 Contractor.

Sage strongly recommends getting a Twilio account for sending emails from within Sage 100 Contractor.

Sage 100 Contractor needs two pieces of information to use a Twilio account: a Twilio Sender ID (for example, “[email protected]”) and a Twilio SendGrid API Key (typically, about 70 characters starting with “SG.”).

Small business configuration options

A small office (less than 5 workstations) can potentially save money by using:

• Windows 10 Professional or Windows 11 Professional for the server operating system
• SQL Server Express Edition, which is free from Microsoft
• Workgroups instead of a domain controller
• A free Twilio account for up to 100 outbound emails a day

SQL Server editions

There are 5 editions of Microsoft SQL Server: Express, Standard, Web, Enterprise, and Developer.

Enterprise and Developer include all features.

Web and Standard include a subset of features.

Express has a limited set of features but is free for commercial use.

If SQL Server has not been installed on the server, Database Administration offers to install and configure a free Microsoft SQL Server 2019 Express Edition automatically.

SQL Server Express has a 10 GB per database limit. Sage 100 Contractor automatically warns users when an Express database is ≥ 80% full.

Standard and Enterprise editions have no size limit and can more efficiently use all your computer’s CPU and memory.

Operating system editions

Installing Sage 100 Contractor server software and SQL Server on a non-server operating system is suitable only for small offices (less than 5 workstations).

For the server operating system, Personal and Home Editions of Microsoft Windows do not work because they use Simple File Sharing.

Domain membership

Sage 100 Contractor works in workgroup environments and does not require a domain controller. In workgroup environments, each user needs a local machine account on both the server and their workstation. Furthermore, usernames and passwords for each user need to be synchronized manually between the workstation and the server.

For a small office with a handful of workstations, a workgroup configuration is sufficient.

Domain controllers and SQL Server

Although SQL Server can be installed on a domain controller, Microsoft does not recommend it.

For more information, see Installing Sage 100 Contractor (SQL) version 20.4 and later to a domain controller

Ethernet versus Wi-Fi

Sage strongly recommends that customers use Ethernet (wired) networking. Intermittent network connectivity between workstations and the server can cause problems with Sage 100 Contractor.

Microsoft Office versions (optional)

Microsoft Office integration requires Office 2010, or later. Office can be 32-bit or 64-bit.