AgWare software uses Microsoft SQL Server for our Enterprise Database. This database is accessed by Maven, DataLog, and ClickForms. AgWare does not have any specific hardware requirements and recommends that you follow Microsoft's recommendations.
SQL Server 2016 and 2017: Hardware and software requirements can be found at https://learn.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server?view=sql-server-ver16.
SQL Server 2019: Hardware and software requirements can be found at https://learn.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server-2019?view=sql-server-ver16.
SQL Server 2022: Hardware and software requirements can be found at https://learn.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server-2022?view=sql-server-ver16
*Note - Full text search is required component for AgWare.
Full Text Search is not installed by default during SQL Server installation,
On initial installation, click the checkbox near "Full-Text and Semantic Extractions for Search" option on the feature selection window in the SQL Server setup. This feature will be installed along with other components on the server.
If SQL Server was installed without selecting the Full Text Search feature then run the setup again to add this component to the existing SQL Server instance. Although this is additional feature, it cannot used without using the SQL Server database engine.
If you want to check whether Full Text Search is installed in your SQL Server instance, then you can run the below T-SQL statement to get this information:
To Check whether Full text Search is Installed or not, enter the following query
SELECT SERVERPROPERTY('IsFullTextInstalled') AS [Full Text Search Installed];
The output value "IsFullTextInstalled" will return:
1 feature is installed
0 not installed