Database

This screen enables you to select the actions to be taken by Installation Manager (e.g., install) and to specify the machine name, the Anthology Student database, and, if applicable, additional databases for Portal and Talisma Fundraising.

alert The database for Anthology Student 19.0.4 and later requires .Microsoft SQL Server 2016 or higher. The prerequisites check will fail for lower versions.

Set Up the Database

  1. In the Installation menu, click Database. The Database screen for Anthology Student is displayed. Closed

    Database Settings

  2. Click Add to add a line to the Settings screen.

  3. Select an appropriate Action. The following Action values are available:

    • None – Performs no action.

    • Install – Performs a fresh installation or upgrade of a component. You can install or upgrade multiple components at the same time.

    Optional: Click Select All to set the Action field to Install for all components listed on this screen. Click Unselect All to set the Action field to None.

  4. Enter the name of the SQL Server where the Anthology Student database is installed.

  5. Specify the Port number of the SQL server or accept the default (1433).

  6. Specify the name of the Database for Anthology Student. The database name must be unique — ‘master’ is not allowed.

  7. The Version field is populated when you click the Test button.

  8. The Active Directory field is populated when you click the Test button.

  9. Click authentication in the Auth column if you want to override the authentication options from Global Settings for the selected database, for example, to give another user permissions to execute scripts for the selected database. The Database Authentication Options form is displayed. Closed

    Database Authentication Options

    1. Select the Override Global Settings check box to enable the fields on the form.

    2. Optional: Select the Use SQL Authentication check box if SQL authentication is applied.

      The license checks, version number check, SQL script execution, student admin role check, and MSI parameters will use SQL authentication if selected.

    3. Enter the Username and Password of the account that is given the override permissions for the selected database.

    4. Click Test to ensure the user authentication settings are correct. A confirmation message is displayed.  Closed

      User Authenticated

    5. Click OK to save changes on the Options form. The form is closed.

  10. Select the check box for On script errors, continue running scripts if you want the installation process to continue regardless of errors encountered.

    By default, database upgrades will stop if the script encounters any errors. This selection is used if there are custom modifications to the database that are known to cause errors in the upgrade scripts. Selecting this option enables all scripts to be run against the specified database.

    Whether the check box is selected or not, any errors are written to a separate error file for each script, which may be investigated after the script execution. Error logs are stored in the following folder:
    DatabaseServer\C:\Logs\Output.

    The error log is the name of the script, SQL Server, and database name appended with _Errors.txt, for example,
    CampusVue_17.1.00xx_{SQL Server}_{database_name}_Errors.txt)

    There is also an output file that has all of the script output:
    CampusVue_17.1.00xx_{SQL Server}_{database_name}_Output.txt

  11. Click Options (ellipsis) icon to view and edit the Options form. Closed

    CampusNexus Student Database Options  

    The Options form is used to specify databases for Portal and Talisma Fundraising. Corresponding licenses are required.

    • Entering a Portal database is only necessary for an installation that includes the e-Learning component that has a Portal component and license key associated with Anthology Student.

    • The Cornerstone and Donor2 databases are used for Talisma Fundraising in conjunction with the primary Anthology Student database. Installation Manager detects if Talisma Fundraising is enabled in the Anthology Student database.

    Database Options Fields
    Field Description
    Check for Licenses This button queries the Anthology Student database and checks for product licenses. Based on the licenses found, Installation Manager enables the Portal, Cornerstone, and Donor2 fields. If the licenses are not found, the Licensed? field indicates "False" and the fields remain disabled.
    Database Server Name of the SQL server on which the database resides.
    Port Specify the port number of the SQL server or accept the default (1433).
    Database Name Name of the SQL database.
    Current Version This field is populated when you click the Test button.
    Licensed? Indicates whether a license for the product is available.

  12. Click OK to save changes on the Options form. The form is closed.

  13. Click copy icon to copy a line. Edit the copied line as needed.

  14. Click Delete icon to delete a selected line.

  15. Click Test to ensure the setup for the corresponding line is correct. If a test on a particular line fails, check all associated fields and click Test again.

    Note: The Test button operates as follows:

    • Queries the database to get the latest version of Anthology Student and populates the current version field.

    • Uses Windows Admin credentials (see Global Settings) and tests connectivity to the SQL server.

    • Uses the Student Admin user name (see Global Settings) and checks if it exists in the Anthology Student database.

  16. If all tests pass, click right arrows.