Recommended Requirements
MSSQL 2016 Service Pack 1 or higher
Minimum Requirements.
MSSQL 2014
Resources:
- Hardware and Software Requirements for MSSQL 2016 SP1
- MSSQL 2016 SP1 Feature Pack details
- MSSQL 2016 SP1 Release Notes
- SQL Server Storage Best Practices
- Hardware and Software Requirements for Installing SQL Server 2014
- SQL Features Supported by the Editions of SQL Server 2014
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:
Related articles
