|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
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
To connect to SQL Server, ARKES uses the relevant user accounts based on the
authentication mode as listed below:
- 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.
- 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.
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.
ARKES creates databases in SQL Server as per the information
- 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).
- 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
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)
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>
Note: ARKES application won't delete
the Traffic Reports database and it will deleted by manually only.
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).
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.