Database Settings

Vyapin Office 365 Management Suite may be configured to use with Application Database / MS-Access MDB / SQL Server database for its data storage to generate reports. If you choose SQL server settings, it requires an SQL Server running SQL Server 2005 / 2008 / 2012 (Enterprise / Standard / Express editions) to connect and create a new application database. Vyapin Office 365 Management Suite will connect to the specified SQL Server based on authentication mode and user credentials to manage its own application database.

Subsequently, Vyapin Office 365 Management Suite maintains its application settings (Tenant settings, Exchange settings, SharePoint settings, Database settings, E-mail settings, Proxy Settings, Export tasks and history) in a set of XML files created in the application installation folder.
You can also specify Database settings to use by clicking Tools --> Configuration Settings menu in the Vyapin Office 365 Management Suite main application window, as shown below

User Authentication

To connect to SQL Server, Vyapin Office 365 Management Suite uses the relevant user accounts based on the authentication mode as listed below:

  1. Windows Authentication:
    In this method, Vyapin Office 365 Management Suite 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, Vyapin Office 365 Management Suite uses the specified SQL user account and password for running Quick Reports and Power Reports tasks. Vyapin Office 365 Management Suite stores the SQL user name and password as a user profile in 'Stored User Names and Passwords' applet for its usage. Note: Vyapin Office 365 Management Suite expects the user account to have sufficient privileges to create, add to and delete database in the SQL server.

Database creation

Vyapin Office 365 Management Suite creates databases in SQL Server as per the information outlined below:

  1. Reports

    Reports feature in Vyapin Office 365 Management Suite creates a single application database in the default data storage location used by the SQL Server during application launch. Vyapin Office 365 Management Suite uses the following naming convention for its Quick Reports database:

    Vyapin Office 365 Management Suite-Data-<RUNNING SERVER NAME>

    For example: Vyapin Office 365 Management Suite creates 'Vyapin Office 365 Management Suite-Data-RD61' with data ('Vyapin Office 365 Management Suite-Data-RD61.mdf') and log ('Vyapin Office 365 Management Suite-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).

Database cleanup

Vyapin Office 365 Management Suite will delete the Built-in Reports database while uninstalling the Vyapin Office 365 Management Suite application from the machine.