MSSQL Server Configuration Recommendations

Recommended version

MSSQL 2016 Standard or Enterprise versions - Service Pack 1 or higher

(Note: MSSQL 2016 requires use of Server 2012 or higher to operate)

Minimum Required Version

MSSQL 2014 Standard or Enterprise

(Note: To enable the AGRIS AUDIT tool MSSQL 2014 Enterprise or higher is required (Available in 2017))

Resources:

MSSQL 2016 SP1 - Standard or Enterprise (Preferred)

MSSQL 2014 R2 - Enterprise edition

NOTE: If you foresee the need to perform audits of the database, consider using MSSQL 2016 Service Pack 1 Standard/Enterprise Editions

News you can use...

Curious about testing using MSSQL express? In most cases, the typical AGRIS database exceeds the capacity for SQL Server Express.
Typically the database size will increase by roughly ~4-5X the current pervasive size for each dataset.

SQL Server 2014 Express - Limitations: Microsoft SQL Server Express supports 1 physical processor, 1 GB memory, and 10 GB storage.
https://msdn.microsoft.com/en-us/sqlserver2014express.aspx

Firewall Settings needed for AGRIS Client connections to SQL datasets:

If you need your AGRIS SQL clients to connect through a firewall, you will need to set Inbound rules to open UDP ports 1433 and 1434 and add a custom rule for the SQL Server (AGRIS) service. Otherwise, you may encounter an error similar to the following: