Database Settings

Vyapin NTFS Security 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 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 NTFS Security 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 menu in the Vyapin NTFS Security Management Suite main application window and choose Database settings, as shown below
 


 

Note: SQL Server option is not applicable to NTFS Security Manager module.

User Authentication

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

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

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

Database creation

Vyapin NTFS Security 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 VyapinNTFSSecurityManagementSuite. Inside the VyapinNTFSSecurityManagementSuite database, separate tables will be created for each installation of NTFS Security Vyapin NTFS Security Management Suite. The table names will be prefixed with the computer name that is running Vyapin NTFS Security Management Suite application. Thus, each installation of Vyapin NTFS Security Management Suite will deploy its own tables based on the computer where Vyapin NTFS Security 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.

    •  VyapinNTFSSecurityManagementSuitetmpSchduleInfo database will be created in the SQL server for scheduled tasks.

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


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

    • VyapinNTFSSecurityManagementSuitetmpSchduleInfo<COMPUTERNAME> database will be created in the SQL server for scheduled tasks.

    • For example, if the computer running the Vyapin NTFS Security Management Suite is ‘CLIENT01’, Vyapin NTFS Security Management Suite creates 'VyapinNTFSSecurityManagementSuite-CLIENT01' with data ('VyapinNTFSSecurityManagementSuite-CLIENT01.mdf') and log (''VyapinNTFSSecurityManagementSuite-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).