Skip to Content
Information
Unsupported content This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Creating databases and users on SQL Server

This topic describes how to create product-related databases and users for the Microsoft SQL Server database.

Warning

Note

While performing these steps, BMC recommends that you review the SQL Server documentation for instructions on how to create databases and users.

Creating databases

Create the databases shown in the following table. You can use different database names than those used in the table examples. Make a note of the database names for reference during the 

Warning

The macro unmigrated-inline-wiki-markup from Confluence is no longer available.

installation.

SQL Server databases

Database name

Purpose

BSARA_DW_DB

Storage of the warehouse tables

BSARA_ETL_MASTER_DB

Storage of the ETL tool repository

BSARA_ETL_WORK_DB

Storage of the ETL tool repository

BSARA_PORTAL_DB

Storage of the portal content store

The following settings are also recommended:

  • The database recovery model should be set to Simple. If there is a crash, you can rebuild the database by running ETL.
  • Set the server-level setting of Maximum Server Memory to 80% of the physical memory on the server. For example, if the server has 6 GB of memory, set Maximum Server Memory to 4.7 GB.

Creating the SQL Server users

You can use different login names than those used in the following table. Make a note of the user names and passwords for reference during the 

Warning

The macro unmigrated-inline-wiki-markup from Confluence is no longer available.

installation.

SQL Server users

User

Description

BSARA_DW

This user has the following responsibilities:

  • Is owner (dbo) of the reports database
  • Is the default database, BSARA_DW_DB
  • Executes ETL jobs (using JDBC connectivity) by reading data from the BMC Server Automation database across the database link
  • Connects to the IBM Cognos reports layer and executes report queries

BSARA_ETL_MASTER

This user has the following responsibilities:

  • Is owner (dbo) of the ETL master repository database
  • Is the default database, BSARA_ETL_MASTER_DB
  • Uses JDBC connectivity for ETL job execution

BSARA_ETL_WORK

This user has the following responsibilities:

  • Is owner (dbo) of the ETL work repository database
  • Is the default database, BSARA_ETL_WORK_DB
  • Uses JDBC connectivity for ETL job execution

BSARA_PORTAL

This user has the following responsibility:

  • Is owner (dbo) of the portal content store database
  • Is the default database, BSARA_PORTAL_DB

Use BSARA_DW (or the name you choose for this user) to create the reports data warehouse schema. as described in Creating-the-reports-warehouse-schema-on-SQL-Server. The other users are used during the 

Warning

The macro unmigrated-inline-wiki-markup from Confluence is no longer available.

installation to create the ETL repository data.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC Decision Support for Server Automation 8.3