Skip to main content

HandiSoft Technical - SQL Server minimum requirements

Updated over a month ago

SQL Server Edition - Minimum Requirements

SQL System Requirements

  • 100 GB available hard disk space

  • .Net framework 4.7 or above

  • 32 GB system memory

  • x64 Processor: AMD Opteron, AMD Athlon 64, Intel Xeon with

  • Intel EM64T support, Intel Pentium IV with EM64T support

Database Server

  • Microsoft SQL Server 2022

  • Microsoft SQL Server 2019

  • Microsoft SQL Server 2017

  • Microsoft SQL Server 2014, 32 and 64-bit

  • Microsoft SQL Server 2012, 32 and 64-bit

Microsoft has released SQL 2019, SQL 2017, and SQL 2016 in 64-bit only.
​
SQL Express is not recommended due to, but not limited to:

  • Maximum database size of 10 GB

  • Maximum 1410 MB of memory

  • Maximum compute of 1 socket or 4 cores

  • No support for Always On

  • No SQL Job Agent

  • No SQL Analysis Services

  • No SQL Integration Services

SQL Migration

HANDISOFT uses the above SQL Server. If you would like to use a different edition of SQL Server other than the one provided, you can consult Microsoft documentation for specific requirements for that edition.
We recommend using the latest SQL server edition, http://msdn.microsoft.com/en-us/library/ms143506.aspx

SQL Installation Requirements

Mixed mode authentication (SQL system admin and Windows authentication).
​
The collation has to be Latin1_General_CI_AS (Windows case-insensitive Accent sensitive).

SQL User Account Requirements

An SQL HandiSoft account needs to be created. We do not recommend that you use the SQL SA (system admin) account

Did this answer your question?