DBConnections.config
This file should reside in the AGRIS\bin folder and should already be configured for AGRIS since it is required for AGRIS to run on MSSQL. Connections for the Audit databases (connection names CulturaAudit.CulturaAudit and CulturaAudit.Accelerator) must be added. There are many variations of the dbConnections.config. Below we have provided some examples. Please contact your system administrator or database administrator for assistance.
Below you will see an example of dbconnections.config. Lines beginning with <!-- are comment lines. These are example connection string lines.
The items that are in blue can be changed to support your specific configuration. Please do not change any other areas.
<!-- the ConnectionString below is an example using SQL Server authentication with SQL Server without instance name →
<!-- <ConnectionString>Server=servername;Database=Audit;User ID=userid;Password=userpassword;</ConnectionString> -->
<!-- the ConnectionString below is an example using SQL Server authentication with SQL Server instance name -->
<!-- <ConnectionString>Server=servername\instancename;Database=Audit;User ID=userid;Password=userpassword;</ConnectionString> -->
<!-- the ConnectionString below is an example using SQL Server Trusted Connection with SQL Server instance name
<!-- <ConnectionString>Server=servername\instancename;Database=Audit;Trusted_Connection=True;</ConnectionString> -->
<!-- the ConnectionString below is an example using SQL Server Trusted Connection without SQL Server instance name
<!-- <ConnectionString>Server=servername;Database=Audit;Trusted_Connection=True;</ConnectionString> →
<!-- servername can be replaced by a valid machine name or a valid ip address or a . →
<!-- if there is an instance name then append it to the servername such as servername\instancename →
<!-- Only change the values for Server, Database, User ID and Password -->
<DBConnections>
<DBConnection>
<ConnectionName>CulturaAudit.CulturaAudit</ConnectionName>
<ConnectionString>Server=.;Database=Audit;User ID=sa;Password=password1;</ConnectionString>
</DBConnection>
<DBConnection>
<ConnectionName>CulturaAudit.Accelerator</ConnectionName>
<ConnectionString>Server=.;Database=Audit_Accel;User ID=sa;Password=password1;</ConnectionString>
</DBConnection>
</DBConnections>
SQL Server Agent Service
The SQL Server Agent Service is the process that makes sure the changes tracked by CDC are written out properly. Make sure this service is running or Audit will not be able to find any of your changes.
Create Icon - Windows 10 Example
In order to run the Audit application, a new shortcut needs to be created. Right click on your desktop and select New>Shortcut.
In the following dialog select or type in the location of CulturaAudit.SmartClient.Shell.exe. It should reside in your AGRIS\bin folder. Click Next.
Change the name of the shortcut to "Greenstone Audit." Click Finish.
Right click the new shortcut and select "Properties." Then click "Advanced."
Check the "Run as administrator" box and click "OK."
Continue backing out of the dialog saving the changes and you're ready to run Audit.
