Database Settings

ARKWE may be configured to use either MS-Access MDB or SQL Server database for its data storage to generate reports. If you choose SQL server ARKWE requires an SQL Server running SQL Server 2005 / 2008 / 2012 (Enterprise / Standard / Express editions) to connect and create a new application database. ARKWE will connect to the specified SQL Server based on authentication mode and user credentials to manage its own application database. 

You can access the Database settings by clicking Tools -> Configuration Settings menu in the ARKWE main application window and choose Database settings, as shown below 
 


 

User Authentication

To connect to SQL Server, ARKWE uses the relevant user accounts based on the authentication mode as listed below:

  1. Windows Authentication:
    In this method, ARKWE uses the currently logged on user account while running reports

  2. SQL Authentication:
    In this method, ARKWE uses the specified SQL user account and password while running reports. ARKWE stores the SQL user name and password as a user profile in 'Stored User Names and Passwords' applet for its usage. 

    Read User Connection Profiles for more details.

    Note: ARKWE expects the user account to have sufficient privileges to create, add to and delete database in the SQL server.

Database creation

ARKWE creates databases in SQL Server based on the following database options (whichever is selected) as outlined below:

  1. Use a single central database for all instances of the application

    • A new database will be created in the SQL server by the name ARKWE. Inside the ARKWE database, separate tables will be created for each installation of ARKWE. The table names will be prefixed with the computer name that is running ARKWE application. Thus, each installation of ARKWE will deploy its own tables based on the computer where ARKWE is installed. For example, if you install the software on 3 different computers, single database with 3 different tables will be created inside the single database and each installed application will generate reports separately independent of each other.

  2. Use a separate database for each instance of the application


    • ARKWE creates a single application database in the default data storage location used by the SQL Server during application launch. ARKWE uses the following naming convention: ARKWE-<COMPUTERNAME>, where COMPUTERNAME is the name of the computer running ARKWE.


    • For example, if the computer running ARKWE is ‘CLIENT01’, ARKWE creates 'ARKWE-CLIENT01' with data ('ARKWE-CLIENT01.mdf') and log (''ARKWE-CLIENT01_log.LDF') files stored in the default SQL data folder in the SQL server (for example, C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data). 
Database cleanup

ARKWE will delete the application database while uninstalling the ARKWE application from the computer.