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
To connect to SQL Server, ARKWE uses the relevant user accounts based on the
authentication mode as listed below:
In this method, ARKWE uses the currently logged on user account while running reports
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.
ARKWE creates databases in SQL Server
based on the following database options (whichever is selected) as
- 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.
- 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
ARKWE will delete the application
database while uninstalling the ARKWE application from the computer.