Preparing your external Microsoft SQL Server database

Prepare your external Microsoft SQL Server database by using the provided the database preparation scripts.

Before you begin

Download the external Microsoft SQL Server scripts from the IBM® Maximo® Application Suite CLI GitHub.

About this task

For more information about preparing your database for installation, see SQL Docs: Encrypting Connections to SQL Server on Linux.

Procedure

  1. Install your Microsoft SQL Server database by using the provider's documentation.
  2. Create the database and user by running the following command: 
    CREATE DATABASE "mref" collate SQL_Latin1_General_CP1_CI_AS;
use mref;
CREATE LOGIN puriuser
          WITH PASSWORD = 'puripass',
       DEFAULT_DATABASE = mref,
           CHECK_POLICY = OFF;
exec sp_changedbowner 'puriuser','puriuser';
  3. Set up SSL and extract the certificate by running the following script as a root user:
    Note: This step enables SSL at the instance level. If other databases in the instance do not require SSL to be enabled, consider moving the IBM Maximo Real Estate and Facilities database into its own separate instance.
    ./ssl-setup.sh