Database Settings

Vyapin Office 365 Management Suite may be configured to use with Application Database / SQL Server database for its data storage to generate reports. If you choose SQL server settings, it requires an SQL Server running SQL Server 2008 / 2012 / 2016 (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, OneDrive Settings, Database settings, Other settings, Export tasks and history) in a set of XML files created in the application installation folder.

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 Interactive Reports and uses 'Run As' account while running Schedule Reports 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 Interactive Reports and Schedule Reports. 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.