Setup the database

Setup the database

Database Setup

Create New Database

In Server Management studio:

1. Right click on the folder ‘Databases’ and select ‘New Database’.

The below dialog will be displayed:

 

2. Enter the Database name - (Usually the name of your finance company or an abbreviated form of this)

3. The default settings for the database can be accepted. 

4. [OK]

Apply Security Permissions to the new Database

If the Server role of ‘dbcreator’ has been used, you will need to give the SQL Server login permission to access the database. 
 
1. Go to Security | Logins  

2. Select and then Right Click on the User Login

3. Select Properties to display the below dialog

 

4. Select the ‘User Mapping’ settings to display the below dialog:

 

5. Check on the ledger database.

6. Check on the db_owner and public role memberships

The dialog should now appear as below (database name will be different)

 

7. [OK] to save

8. For new / ‘starter’ installations: Restore the “Starter Database” that has been provided by Argos

For existing customers who are upgrading their server: Restore the database backup taken prior to performing the upgrade. 

9. Take a backup of the newly created ledger database with the login permissions set, as restoring a database backup taken prior to this setup will overwrite the database access settings.

    • Related Articles

    • Installing Argos Bailment

      Argos Bailment Installing the Bailment Module Application Note: Argos Bailment is a licenced module that is run independently of Argos Vault. If you are not licenced for this module, then this section can be disregarded. New Installations Double ...

    • Installation Instructions

      Summary This set of documents details the initial setup requirements for the Argos software. It is recommended that the installation checklist from the appendices is printed as a step by step guideline for the installation task being undertaken. The ...

    • Installation Prerequisites

      Prerequisites The following section outlines the third-party applications required to successfully run Argos. The below applications are not provided as part of the Argos application and it is the responsibility of the client to purchase/licence, ...

    • Installing Argos Internal API

      The Argos Internal API is used to power the Vault and Bailment applications. Note, this is available from Argos v6.0 onwards Installation Types The installer can be used to install a production instance of the Argos Internal API. Instructions to ...

    • Installing SQL Server

      SQL Server Setup The .Net 4.8 framework and C++ Redistributables MUST be installed on the server machine prior to SQL installation. See Prerequisites for further details. SQL Server Express The instructions below are provided to assist smaller ...