To store informations of the configuration 3 databases are required for RTCLauncher:

  1. Main database - to store application configuration.
  2. Reporting database – to store reporting data.
  3. Logging database – to store all application logs.

SQL Compatibility

Supported Platforms for the Database are:

  • Microsoft SQL Server 2012
  • Microsoft SQL Server 2014
  • Microsoft SQL Server 2016
  • Microsoft SQL Server 2017

Main Database Creation 

Enable Contained Database

  1. Check that contained databases are enabled on the server.

  2. Go to server Properties:

    Server PropertiesEnable contained databases setting

  3. Select Advanced tab.

  4. Set property Containment > Enable Contained Databases to True

Create Empty Database

  1. On your server folder tree expand the Databases folder, select "New Database".

    New Database
  2. In the opened "New Database" window, select the following options: 
    1. Containment type: Partial
    2. Collation to Latin1_General_CI_AS
  3. Create user with System Administrator permissions on the new DB. → Read chapter below.
  4. Run CreateStructure.sql script to create RTC Launcher DB structure.

Creation of DB Users / Administrator Permissions on SQL Server Machine

To grant the administrator permissions use the following steps:

Create User

  1. Go to the machine where SQL Server is installed.
  2. Open Microsoft SQL Server Management Studio.
  3. Create new SQL server user as follows:
  4. In the folder tree expand the Databases folder, expand the folder of your database, expand Security folder.
  5. Launch context menu of the Users folder and choose New User…
  6. In the opened Database User – New window handle according to your case:
    1. Case A - Integrated Security, different machines
    2. Case B - Integrated Security, same machine
    3. Case C - SQL Login

Case A 

DB connection is performed using Integrated Security and RTC Launcher and SQL server are running on different machines:

  • Choose Windows user user type
  • Fill the User Name field and put the $ sign on the end of computer name along with domain name (dev\rtc01$ for example)
  • Set Default schema to dbo
  • Continue with the user permissions (→ see below)

(lightbulb) Note: dev\rtc01$ - is a computer account (each computer that joins the domain has it to apply policy settings). It will be used to access the database. This is because RTC Launcher is running "NT AUTHORITY\Network Service security context with Integrated Security" enabled by default in its configuration file.

Case B 

DB connection is performed using Integrated Security and RTC Launcher and SQL server are running on one machine:

    • Choose Windows user user type
    • Fill the User Name field with NT AUTHORITY\NETWORK SERVICE value
    • Set Default schema to dbo
    • Continue with the user permissions (→ see below)

Case C 

DB connection is performed using SQL server login and password:

    • Choose SQL user with password user type
    • Fill the User name
    • Fill Password and Confirm Password fields
    • Set Default schema to dbo 
    • Continue with the user permissions (→ see below)

Grant Permissions

  1. On any user select the Membership tab
  2. Select the db_owner role.
  3. Confirm creation of the new user
  4. Edit "Create_Main.bat" and update DB connection settings. The file will be provided by a Luware representative
  5. Run "Create_Main.bat" to create DB structure

Reporting Database Creation*

  1. Create an empty database
  2. Create user as described above.
  3. Give user db_owner role as described above.
  4. Run "CreateStructure_2_0_Reporting.sql". The file will be provided by a Luware representative

Logs Database Creation

  1. Create an empty database
  2. Create user as described above.
  3. Give user db_owner role as described above.
  4. Run "CreateStructure_2_0_Logging.sql". The file will be provided by a Luware representative