Microsoft SQL Server

This section contains the necessary steps for installing the database of LumisXP on Microsoft SQL Server servers:

Open SQL Server Management Studio, create a new database and run the script db_sqlserver.sql.
Enable the isolation level SNAPSHOT on the created database by executing the following SQL:
ALTER DATABASE <database_name> SET READ_COMMITTED_SNAPSHOT ON;
In the file lumisdata/config/lumishibernate.cfg.xml, change the database connection information.
 <property name="dialect">lumis.portal.dao.hibernate.SqlServerDialect</property> <property name="connection.driver_class">com.microsoft.sqlserver.jdbc.SQLServerDriver</property> <property name="connection.username"> DB_USERNAME </property> <property name="connection.password"> DB_PASSWORD </property> <property name="connection.url">jdbc:sqlserver://localhost:1433;databaseName=lumisportal;applicationName=LumisXP;sendStringParametersAsUnicode=false</property>

Another alternative for connecting to the database is the configuration of the datasource in the application server.

Note

This configuration above does not enforce the use of encryption, but it may attempt to use it depending on the SQL Server settings. Additional configurations may be necessary for encrypted connection to work, which could result in being unable to connect to the database if not properly configured. For more information on how to configure connection encryption, see https://learn.microsoft.com/en-us/sql/connect/jdbc/using-ssl-encryption.
Run the file /setup/initializeportal.cmd for Windows®, or initializeportal.sh for Linux. This script runs a Java application that opens a connection to the database, using the information from the file lumisdata/config/lumishibernate.cfg.xml. This script also inserts the initial data necessary for the operation of LumisXP.