Installation Guide Litmus Production Record Database

how to deploy litmus production record database this section will provide instructions on how to deploy litmus production record database to a preinstalled ms sql server note if you have been using litmus production record internal event configurator , make sure to get at least version 1 1 0 of this tool after updating to litmus production record database v 1 3 0 0 requirements full version of microsoft sql server 2017 or higher is deployed supported editions enterprise, standard, developer, express a sql authentication user with the rights to deploy and manage databases such as the sa user the sql server is reachable via its ip / the ip for the sql server is known to run the installer, the net version has to be 4 7 2 or higher note many organizations will not allow to use the default sql authentication user sa in their production environments to ensure that litmus production record database can operate and has all the right permissions, it is recommended to use, only for the installation, a user which has similar privilege's as the sa user such a user can for example be created with a script like this sql use \[master] go / for security reasons the login is created disabled / create login \[litmus] with password=n'mysupers3cr3tpa$$w0rd', default database=\[master], default language=\[us english], check expiration=off, check policy=on go alter login \[litmus] disable go alter server role \[sysadmin] add member \[litmus] go which creates a user called litmus with the password mysupers3cr3tpa$$w0rd once the user is enabled, it can be used to install litmus production record database as this user has sysadmin permissions, for day to day operation such as reading or writing data a different user, not with the sysadmin role, should then be used supported operating systems windows operating systems linux https //learn microsoft com/en us/sql/linux/sql server linux overview?view=sql server ver16 deployment options docker container kubernetes datacenter azure > any virtual machine with sql server installed ( not azure sql database ) step by step guide to install litmus production record database this guide will provide instructions on how to install litmus production record database on a new sql server or update an existing installation this guide will not provide instructions on how to use or configure the various aspects of litmus production record database these instructions are provided through the solutions documentation portal https //public docs litmus io/solutions step 1 download the installer from central portal step 2 run the installer step 3 provide the three mandatory inputs for the sql authentication sql server name / ip > the ip (not host / dns name) of the sql server sql authentication user > the sql authentication user (not windows accounts user) password > the sql authentication user password (not windows account password step 4 the installer will check if litmus production record database is already installed if yes , it will retrieve the path where it is deployed if no , it will retrieve the default path for databases to be deployed to step 5 optional for a new installation , users can optional modify the path for the database file and log file note the database directory specified has to exist before running the installer as sql server can not create a missing directory step 6 press the create/update litmus production record button step 7 the progress is shown through the log screen the installation is finished if the line "productionrecord db installation/update completed " is shown