Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...

Recommended

...

version 

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

Minimum Requirements. 

MSSQL 2014

...

        • (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  (Avaialbe in 2017))

Resources:

  1. SQL Server Storage Best Practices

MSSQL 2016 SP1 - Standard or Enterprise (Preferred)

  1. Hardware and Software Requirements for MSSQL 2016 SP1

...

...

...

...

...

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

Info

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:

Image Modified

Filter by label (Content by label)
showLabelsfalse
max5
spacesACD
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel = "mssql" and type = "page" and space = "ACD"
labelsMSSQL

Page Properties
hiddentrue
Related issues