Recommended Requirements
MSSQL 2016
Minimum Requirements.
MSSQL 2014
Resources:
- Hardware and Software Requirements for MSSQL 2016 SP1
- MSSQL 2016 SP1 Feature Pack details
- MSSQL 2016 SP1 Release Notes
- Hardware and Software Requirements for Installing SQL Server 2014
- SQL Server Storage Best Practices
- SQL Features Supported by the Editions of SQL Server 2014
NOTE: If you foresee the need to perform audits of the database, consider the following:
- If you need to upgrade to this version of MS/SQL or purchase it, please consider the SQL Server 2014 Enterprise edition OR
- Wait until we finish testing SQL Server 2016 as both the Standard and Enterprise versions of 2016 support audits.
News you can use...
- Curious about testing using MSSQL express? In most cases, the typical AGRIS database set exceeds the capacity for SQL Server Express.
- Typically the relational model changes would expand your database size 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:
Related articles
