Configure SQL Server

ARKES uses SQL Server database for its data storage to generate Exchange reports. ARKES requires an SQL Server running SQL Server 2005 / 2008 / 2012 (Enterprise / Standard / Express editions) to connect and create a database. ARKES will connect to the specified SQL Server based on authentication mode and user credential to manage its own application databases.

ARKES will prompt for the SQL settings (Server name, authentication mode, user name and password) when Built-in Reports / Power Reports / Custom Reports feature is launched for the very first time. SQL Database Settings dialog appears as shown below :

Subsequently, ARKES maintains its application settings (SQL settings, E-mail settings, Power Reports tasks and history) in a set of XML files created in the application installation folder.
You can also specify SQL Server settings to use by clicking Tools --> Configuration Settings menu in the ARKES main application window, as shown below

User Authentication

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

  1. Windows Authentication:
    In this method, ARKES uses the currently logged on user account while running Quick Reports (under interactive mode) and uses 'Run As' account while running Power Reports task (run as a scheduled task or using Run Now option) to authenticate the user in SQL Server.
  2. SQL Authentication:
    In this method, ARKES uses the specified SQL user account and password for running Quick Reports and Power Reports tasks. ARKES stores the SQL user name and password as a user profile in 'Stored User Names and Passwords' applet for its usage.

    Read Profile Manager for more details.

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

Database creation

ARKES creates databases in SQL Server as per the information outlined below:

  1. Built-in Reports

    Built-in Reports feature in ARKES creates a single application database in the default data storage location used by the SQL Server during application launch. ARKES uses the following naming convention for its Quick Reports database:

    ARKES-Data-<RUNNING SERVER NAME>

    For example: ARKES creates 'ARKES-Data-RD61' with data ('ARKES-Data-RD61.mdf') and log ('ARKES-Data-RD61_log.LDF') files stored in the default SQL data folder in the SQL server (C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data).

  1. Power Reports

    Power Reports feature in ARKES creates a database in the default data storage location used by the SQL Server for every run instance of the Power Reports (scheduled) task, either at the scheduled time interval or when using Run Now option. ARKES uses the following name convention for its Power Reports database:

    ARKES-Data-<RUNNING SERVER NAME>-<TASK NAME>-<yyyymmddhhmmss>

    For example: ARKES creates 'ARKES-Data-RD48-MailboxTask-20100103043507' with data ('ARKES-Data-RD48-MailboxTask-20100103043507.mdf') and log ('ARKES-Data-RD48-MailboxTask-20100103043507_log.LDF')

    The above files are stored in the default SQL data folder in the SQL server (C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data)

  1. Traffic Reports

     Traffic Reports creates a seperate databases in the SQL Server as per the information outlined below:

    It creates a single application database in the default data storage location used by the SQL Server during application launch. Traffic Reports uses the following naming convention for its feature database:

    ARKES-TrafficReports-Data-<RUNNING SERVER NAME>

    For example, it creates 'ARKES-TrafficReports-Data-RD61' with data ('ARKES-TrafficReports-Data-RD61.mdf') and log ('ARKES-TrafficReports-Data-RD61_log.LDF') files stored in the default SQL data folder in the SQL server (C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data).

    Note: ARKES application won't delete the Traffic Reports database and it will deleted by manually only.
Database cleanup

ARKES will delete the Built-in Reports database while uninstalling the ARKES application from the machine. 

ARKES deletes the Power Reports database after generating the reports as specified by the user. You can also cleanup the ARKES databases corresponding to a task or a task history instance using the 'Remove History' or 'Cleanup History' options in ARKES main application.

Traffic Reports database will deleted by manually only.