Database Settings

Vyapin Virtualization Management Suite 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 Vyapin Virtualization Management Suite requires an SQL Server running SQL Server 2005 / 2008 / 2012 (Enterprise / Standard / Express editions) to connect and create a new application database. Vyapin Virtualization Management Suite 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 Configuration -> Configuration Settings tab in the Vyapin Virtualization Management Suite main application window and choose Database settings, as shown below 
 


 

User Authentication

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

  1. Windows Authentication:
    In this method, Vyapin Virtualization Management Suite uses the currently logged on user account while running reports

  2. SQL Authentication:
    In this method, Vyapin Virtualization Management Suite uses the specified SQL user account and password while running reports. Vyapin Virtualization Management Suite 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: Vyapin Virtualization Management Suite expects the user account to have sufficient privileges to create, add to and delete database in the SQL server.

Database creation

Vyapin Virtualization Management Suite creates databases in SQL Server based on the following database options (whichever is selected) as outlined below:

  1. Use a single central database for all instances of the application

    • A new database will be created in the SQL server by the name Vyapin Virtualization Management Suite. Inside the Vyapin Virtualization Management Suite database, separate tables will be created for each installation of Vyapin Virtualization Management Suite. The table names will be prefixed with the computer name that is running Vyapin Virtualization Management Suite application. Thus, each installation of Vyapin Virtualization Management Suite will deploy its own tables based on the computer where Vyapin Virtualization Management Suite 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.

  2. Use a separate database for each instance of the application


    • Vyapin Virtualization Management Suite creates a single application database in the default data storage location used by the SQL Server during application launch. Vyapin Virtualization Management Suite uses the following naming convention: VyapinVirtualizationManagementSuite-<COMPUTERNAME>, where COMPUTERNAME is the name of the computer running Vyapin Virtualization Management Suite.


    • For example, if the computer running Vyapin Virtualization Management Suite is ‘CLIENT01’, Vyapin Virtualization Management Suite creates 'Vyapin Virtualization Management Suite-CLIENT01' with data ('Vyapin Virtualization Management Suite-CLIENT01.mdf') and log (''Vyapin Virtualization Management Suite-CLIENT01_log.LDF') files stored in the default SQL data folder in the SQL server (for example, C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data). 
Database cleanup

Vyapin Virtualization Management Suite will delete the application database while uninstalling the Vyapin Virtualization Management Suite application from the computer.