Recommended server configuration Operating System - Windows Server 2022
- Windows Server 2019
- Windows Server 2016
- Windows Server 2012 R2
Note: Windows Essentials Edition and domain controllers are not supported. SQL software If you plan to use Sage SQL Replicator, you will need SQL Server version 2016 SP1 to SQL Server 2019. Note: As of SQL Server 2022 Microsoft does not allow changing of the collation settings, therefore it is not supported at this time. You can use the Sage SQL Installer (in the Sage Administration program group). The size of the replicated data in SQL Server is larger than the original Pervasive data because Sage SQL Replicator adds views and indexes the data. You can use SQL Express (available at no extra cost) if your database isn't too large. Otherwise, you must use full SQL Server (Standard Edition or Enterprise Edition). See How do I estimate what the size of my SQL Database will be once I run Sage SQL Replicator? for more information. Hardware Depending on your use of Sage SQL Replicator, use a physical machine or VM with the dedicated resources shown below: - Not using replicator or replication of one small (0-2 GB) data folder:
- CPU: Current generation multi-core processor* with 4+ cores; 1.6+GHz
- RAM: 8+ GB**
- Hard drive: Hard Disk Drive (HDD) or Solid State Drive (SSD)
- Replicator of multiple medium (2-6 GB) data folders:
- CPU: Current generation multi-core processor* with 4+ cores; 2+ GHz
- RAM: 16+ GB**
- Hard drive: Hard Disk Drive (HDD) or Solid State Drive (SSD)
- Replicator of multiple medium (2-6 GB) or large (6+ GB) data folders***:
- CPU: Current generation multi-core processor* with 8 cores; 2.4+ GHz
- RAM: 32+ GB**
- Hard drive: Hard Disk Drive (HDD) or Solid State Drive (SSD) with 200 MB/seconds of sustained read/write throughput
*Such as Intel® Core i3™, Intel® Core i5™, Intel® Core i7™ or Intel® Xeon™. **Depending on the size and number of your databases, the number of concurrent users, and if additional business applications are hosted on the same server. ***May require full SQL Server version Recommended client configuration Operating System - Windows 11 Pro (64-bit) (Home is not supported)
- Windows 10 (64-bit) (Professional and Enterprise. Home is not supported)
Hardware Use a physical machine or VM with the resources shown below: - CPU: Current generation multi-core processor (such as Intel® Core i3™, Intel® Core i5™, Intel® Core i7™ or Intel® Xeon™) with 2GHz+
- RAM: 8+ GB
- Hard drive: Hard Disk Drive (HDD) or Solid State Drive (SSD)
Other Configuration Requirements Network - Wired Network Adapter
- Desktop client workstations must have a wired network connection to the server.
- Desktop client users who connect to your company's network through WiFi or VPN must open a Remote Desktop connection to the client machine on which Sage 300 Construction and Real Estate is installed.
- Ports - Software and Hardware firewalls must be setup to accept these ports: 25, 80, 137 - 139, 443, 515/TCP, 1583/TCP, 3351/TCP, 8101, 8102, 11486 - 11488/TCP, plus additional ports as required for SQL Server.
- Windows Active Directory domain is required for Sage SQL Replicator and Mobile features.
Software - Microsoft .NET 4.6.2
- Microsoft .NET 3.5
- Adobe Reader
- Microsoft 365, Office 2016, or Office 2013 (only 32-bit versions are supported). To ensure compatibility with Sage 300 CRE, the Click-to-Run installation method for these Office products is not recommended.
- SAP Crystal Reports for Sage 300 Construction 2016 (for modifying and creating Crystal Reports designs)
Peripherals - Monitor Resolution - 1024 pixels by 768 pixels up to 1920 pixels by 1080 pixels (Full HD). Avoid monitors with 2K resolution.
- Printer - A Microsoft-certified printer driver is recommended.
Supported Browsers See Also: How do I estimate what the size of my SQL Database will be once I run Sage SQL Replicator? |