What Server, Hardware & Operating System is needed to run Acclamare?
- Acclamare is built on Microsoft Windows platform.
- Acclamare runs on operating systems Server 2008 R2 and above. At the time of this writing, this includes 2008 R2, Server 2012, Server 2016, and Server 2019 .
- Acclamare requires SQL Server 2008 R2 or higher. At the time of this writing, this includes SQL Server 2008 R2, SQL Server 2012,SQL Server 2014, SQL Server 2016, and SQL Server 2017.
SQL Server “Standard” edition provides all the features necessary. “Express Edition” will not provide all the features and resources required for production implementation of Acclamare.
As of SQL Server 2012, installing SQL Server on the Active Directory is not recommended by Microsoft. While technically ic can be installed as such, but not employing the restrictive accounts as the SQL Server Service accounts. This results in Acclamare server application limitations, maintenance of reports limitations, and inability to fully utilize SQL Report Subscriptions.
SQL Server and the Acclamare Server applications will be installed on the same server and this server should not be used for any other purposes such as backup software, terminal server hosting, security software, or other applications.
- Acclamare will operate under both Physical and Virtual Servers implementations. Keep in mind to dedicate enough RAM as discussed in following bullet.
- Acclamare itself does not require huge resources, though SQL Server's performance has direct impact upon how well Acclamare performs. The suggested RAM for the SQL Server box/virtual machine is 32GB.
- Enterprise-grade SSD drives will provide outstanding read/write speed for the SQL database. If you are unable to use SDD's.
- SQL Server makes use of database files and transaction log files. As the transaction log file is being being continuously written to, it is recommended that transaction log exist on a drive and controller that is independent from the drive on which the database files exist. A common drive setup includes one drive for for OS plus transaction log and one drive for SQL database. Alternatively, a third drive could be used for the transaction log and other domain file storage needs.
- The following represent a recent server put into service by a hardware provider:
- 2 x 256GB (RAID 1) SSD -- for boot drive and OS
- 2 x 256GB (RAID 1) SSD -- for SQL Installation, SQL data files and Acclamare. Connected to it's own PCIe x1 Controller
- 1 x 512GB HDD or larger -- for other company file storage needs (including the SQL Transactions Logs), connected to the motherboard controller so as to not impede performance on the SQL data file controller.
What Client, Hardware & Operating System is needed to run Acclamare?
- Acclamare client runs on Windows 7 SP1 and above. At present, this includes Windows 7 SP1, Windows Vista, and Windows 10.
- Acclamare client does not require heavy resources. Workstations typically have no less than 4G RAM installed. Users who are heavier multi-taskers (Acclamare plus multiple other applications) would likely be better served by having 8G installed.
- Acclamare client makes heavy use of Dynamic Inquiries. This feature is best used in a dual-monitor configuration. I would go so far as to say that a dual-monitor setup is an essential requirement for most users except for a computer solely begin used for Shipping and Receiving functions.
Permissions, Folders, and Feature Setup
Installation and ongoing maintenance of SQL Server, Acclamare, and SQL Reporting will be performed using the server/domain "Administrator" account, not an account created having "administrator permissions".
The few folder shares will be created on the server and users will be given read/write permissions to these shares.
Acclamare Client application is installed on local PC's within a folder for which the domain user has full read/write permissions.
The server and local PC must have Network Discovery enabled as discussed in a separate article.