Skip to main content

Install the Database

The Usercube Database can be installed on the Server workstation or on a separate machine.

Please make sure that the database requirements are met before going further.

Steps​

1. Install SQL server​

Microsoft's extensive documentation can be used to get help installing a SQL Server 2016 or later.

2. Create the Usercube database​

The recommended naming convention is Usercube<Organization>, where <Organization> is the name of the organization targeted by this installation.

FAQ: How to create a database in SQL Server?

The database name is of no technical importance, but following the naming convention will make it easier to read the guide.

3. Initialize the Usercube database​

The database scheme can be initialized by running the Usercube.sql script (found in the SQL_<version>.zip archive) on the newly created database.

Preferred methods include SQL Server Management Studio and command line.

Example of procedure for SQL Server Management Studio 2019​

  • Open SQL Server Management Studio.
  • Connect to your SQL Server instance.
  • In the top left corner, select File > Open > File.
  • Select the Usercube.sql file.
  • Open the file. The file is now open in the main SQL Server Management Studio window.
  • Locate the database name dropdown, next to the Execute button in the top left section of the screen.

Execute Query

  • From the dropdown, select the newly created database.
  • Click Execute.

Example using the sqlcmd CLI​

sqlcmd -S <ComputerName>\<InstanceName> -d Usercube<Organization_name> -i <Usercube.sql>

What's Next?​

The next step will consist in:

  • Setting up the Usercube Server as an IIS website.
  • Creating a custom service account.
  • Granting the necessary database permissions for this account.

It will also show how to test the Usercube Database connection.