Minimum Requirements.
SQL 2014
Resources:
- 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 need to upgrade to this version of MS/SQL or purchase it, please consider the Enterprise edition if you foresee the need to perform audits of the database.
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.
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
