Configuring Microsoft SQL Server

Perform the following steps to configure Microsoft SQL Server.

Admin Database

    Procedure
  1. Open the $OM_HOME/db/dbscripts/sqlServer/admin/bin/sqlserver_admin_db.properties file in a suitable editor and update the values.

  2. Run the following scripts from the $OM_HOME/db/dbscripts/sqlServer/admin/bin directory:

    db-setup.sh

    seed_common_authConfig_db_setup.sh

Archival Database

    Procedure
  1. Open the $OM_HOME/db/dbscripts/sqlServer/archival/bin/sqlserver_archival_db.properties file in a suitable editor and update the values.

  2. Run the following script from the $OM_HOME/db/dbscripts/sqlServer/archival/bin directory:

    db-setup.sh

Catalog Database

    Procedure
  1. Open the $OM_HOME/db/dbscripts/sqlServer/catalog/bin/sqlserver_catalog_db.properties file in a suitable editor and update the values.

  2. Run the following script from the $OM_HOME/db/dbscripts/sqlServer/catalog/bin directory:

    db-setup.sh

Jeopardy Database

    Procedure
  1. Open the $OM_HOME/db/dbscripts/sqlServer/jeopardy/bin/sqlserver_jeopardy_db.properties file in a suitable editor and update the values.

  2. Run the following script from the $OM_HOME/db/dbscripts/sqlServer/jeopardy/bin directory:

    db-setup.sh

Order Database

    Procedure
  1. Open the $OM_HOME/db/dbscripts/sqlServer/order/bin/sqlserver_order_db.properties file in a suitable editor and update the values.

  2. Run the following script from the $OM_HOME/db/dbscripts/sqlServer/order/bin directory:

    db-setup.sh

User Database

    Procedure
  1. Open the $OM_HOME/db/dbscripts/sqlServer/user/bin/sqlserver_user_db.properties file in a suitable editor and update the values.

  2. Run the following script from the $OM_HOME/db/dbscripts/sqlServer/user/bin directory:

    db-setup.sh

Provide the SQL Server details in each of the configuration files. For more details, see the $OM_HOME/samples/sqlServer-sample-property/sample_sqlServer_properties.properties file.