AGRIS Customer Documentation

New Install - AGRIS MSSQL 2014 - AGRIS 10.3.2 or higher

Owned by Russell Shirley
Last updated: Mar 17, 2017
3 min read

TABLE OF CONTENTS:

Background Notes and Assumptions

  1. These instructions are intended for configuration by people familiar and experienced with MSSQL environments. 
  2. If you are not comfortable or familiar with MSSQL or the following steps, please consult your hardware / I.T. provider for assistance in the MSSQL configuration.
  3. Also See MSSQL - Where do I need to install AGRIS and where do I not?


Step-by-step guide

  1. Install MSSQL 2014 (install the Standard or Enterprise edition).  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.  Click HERE for more information about the features in the various SQL Server Editions.When installing MSSQL choose SQL Security Mode (this is not required just easiest)

    1. Configure to use TCP/IP and Named Pipes = Enabled in SQL Configuration Manager

    2. Ensure that SQL Server Management Studio can be launched and the user can login using the sa account or some other administrative account


  2. Install AGRIS, then apply latest Service Packs and/or Software updates (the system may prompt for a reboot at this time before continuing)

    1. When installing AGRIS on a machine that does not have Pervasive PSQL installed, the following message may appear.  Click Yes on the message to proceed with the installation.



  3. Configure the AGRIS.INI

    1. Data Path=\\machinename\sharename\agris\datasets

      1. While there may be varying 

    2. If you are using a separate standalone SQL Server then the Component Server name should be a common AGRIS instance or it should be the machinename of the machine you are installing.  

      1. Example:AGRISPROD  No back slashes and no folders just the machine name

      2. The Component server should be a common AGRIS instance in most cases

    3. Add the following line Database Type=SQL to the AGRIS.ini (this does not exist so you would type or copyt by hand)


  4. Configure AGRIS\bin\dbconnections.config

    1. copy DBConnections.config.template to dbconnections.config

    2. modify dbconnections.config to use the appropriate login credentials for SQL server user and password.  

      1. There are 3 of these to set in the dbconnections.config.

      2. NOTE:  The attribute names must stay the same, Only change the Values in the connection string, nothing else.  

      3. For example, a modified connection string might look like this:

        <ConnectionString>Server=AGRISSERVER\SQL2014;Database=AGRIS;User ID=sa;Password=sa_p@ssword;</ConnectionString>

        Note that Server may not simply refer to the machine name where the MSSQL database is installed. Ususally the server name in MSSQL consists of 2 parts: the machine name (AGRISSERVER in the example) and the SQL instance (SQL2014 in the example).


  5. Launch AGRIS

    1. If the AGRIS and Accelerator databases have been preconfigured, AGRIS will use the existing MSSSQL databases.  This allows the customer to configure the database(s) based on SQL Server 2014 Enterprise installation best practices while conforming to Corporate Policies and Guidelines.  

    2. If this is a brand new installation of AGRIS and the AGRIS and Accelerator databases have not previously been setup, then launching AGRIS will automatically initialize these databases and you should see the following.


       


    3. As AGRIS is creating a dataset the system should then ask you the following question. 


    4. Success should look like (smile) 





    5. Review the optimization settings below in MSSQL to ensure you have "tuned" the AGRIS configuration to your install. 


Optimization Setting once AGRIS creates the dataset to consider.

  1. Optimizations to consider for the Accelerator Database

      1. Set Recovery Model to Bulk-Simple

      2. Set the DataFile Paths to c:\databases\agris (not required just suggested)

  2. Optimizations to consider for the AGRIS Database

      1. Set Recovery Model to Full (Production) or Bulk-Simple (Testing)

✦✦✦

3820 Mansell Road, Suite 350 ✦ Alpharetta, GA 30022 ✦ www.GreenstoneSystems.com
© 2011 - 2024 Cultura Technologies LLC. All Rights Reserved Worldwide.  Products and company names mentioned herein may be trademarks or registered trademarks of their respective owners.