SessionAudit
  • Infrastructure Documents
  • Overview
    • What is Session Audit
    • FAQs
    • Road Map
    • Licensing
  • Planning
    • POC Requirements
    • Supported Configurations
    • Windows Server Requirements
    • SQL Server Requirements
    • Agent Requirements
    • Other Requirements
    • Network Considerations
    • Design
      • Single Deployment
      • Distributed Deployment
  • Deployment
    • Installing Microsoft SQL Server
    • HTTPS Certificate
    • DNS Records
    • .Net Framework 4.7.2 Download and Install
    • .NET Core 6.0.16 Download and Install
    • Internet Information Service Installation
    • Single Deployment
      • DB Creation
      • IIS and Site Settings
      • Database Permissions
    • Distributed Deployment
    • Upgrade Existing SessionAudit Installation
  • Initial Configuration
    • First time Login to SessionAudit
    • License Management
    • LDAP Settings
    • Role Management
    • Change Admin Password
  • Advanced Configuration
    • Login to the Portal with Domain Account
    • Settings
      • Server Settings
      • Agent Settings
      • LDAP Settings
      • Notification Settings
      • Syslog Settings
  • Managing
    • Dashboard (Home)
    • Tracker
    • Reporting
    • Computers
    • Role Management
    • License Management
  • Troubleshooting
    • SQL Express Usage
    • Securing Windows Server
Powered by GitBook
On this page

Was this helpful?

  1. Deployment
  2. Single Deployment

DB Creation

Installation

PreviousSingle DeploymentNextIIS and Site Settings

Last updated 1 year ago

Was this helpful?

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 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.

Upgrade