DB Creation

Installation

There is a folder named SQL in the directory where the SessionAudit server role is installed. In this folder, there are 2 files named "1-Schema.sql" and "2.Data.sql". These files create the database and built-in data needed by the SessionAudit server role. Follow the steps below to create the database:

1. Run the SSMS (SQL Server Management Studio) management interface from the start menu with the RunAs Administrator command.

2. Go to the Open File window with the File \ Open \ File menu. CTRL+O hotkey combination can be used for this.

3. Go to %PROGRAM FILES%\Arksoft Bilisim\SessionAuditServer\SQL. If this address has been changed during installation, the installation directory must be found and opened.

4. 1-Open the Schema.sql file,

This file is used to create the database, tables and other objects. Do not use for upgrade. Therefore, if there is already a database created for SessionAudit, this script will get an error while running. For this, go to the Upgrade topic.

1. The file contains a description named [@DBNAME]. This information is on line 1. The definition of [@DBNAME] must be the same as the database name specified in the Initial Catalog field in the AppSettings.json file. Below are suggested database names.

• SA4SC

• SessionAudit

1. After the DBNAME variable name is changed, the script is run by pressing the F5 key.

An error may occur in the following cases:

1. If User Account Control is open and SSMS interface is not opened with RunAs Administrator,

2. If the user logged into the SQL interface does not have the sysadmin role,

3. If the user logged into the directory where the database will be created does not have write rights

4. The database name or file may already exist in the system.

1. Second, open the 2-Data.sql file. This file contains the built-in data that should be in the database. Likewise, the [@DBNAME] variable in this file is replaced with the database name. Run the script with the F5 key.