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.
- 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
