Prerequisites for the SQL Server database setup

This topic describes the prerequisites for the Microsoft SQL Server database setup.

Required databases

You need the following databases for SQL Server:

• Portal content store
• Reports data warehouse
• ETL (ODI) master repository
• ETL (ODI) work repository

Database naming and password conventions

When setting up your databases for the BMC Decision Support for Server Automation installation and when adding sites after the installation, ensure that the database names meet these requirements:

• Database names contain only Latin alphabet letters, numbers, and underscores (_).

• Database names do not begin with a number.

• Database names do not contain hyphens (-) in the names. While database names with hyphens work in BMC Server Automation, they do not work in BMC Decision Support for Server Automation.

Database passwords must meet the following requirements:

• Database passwords do not begin with the equal sign (=) character.
• Database names do not begin with an integer.
• Database names do not contain spaces.

Other database requirements

Ensure that the SQL Server databases meet the following requirements:

• The SQL Server content store database and reports data warehouse must use the TCP/IP protocol.
• The SQL Server collation sequence for the content store database and reports data warehouse must be case-insensitive.

For example, SQL_Latin1_General_CP1_CI_AS is a case-insensitive collation sequence.

• Customers using non-English databases (such as Asian customers) should use the nchar character set. Customers using English databases (such as LATIN-1) can use the char character set.

• The reports data warehouse schema type must align with the BMC Server Automation database in one of the following ways:

  • If you have one or more BMC Server Automation databases that use char schema, the reports data warehouse must use char schema.

  • If you have one or more BMC Server Automation databases that use nchar schema, the reports data warehouse must use nchar schema.

  • If you have multiple BMC Server Automation databases and some use char and others use nchar schema, the reports data warehouse must use nchar schema.

  • The character set value for the BMC Server Automation database and the character set value for the reports data warehouse must match.
• The SQL Server collation sequence for the BMC Server Automation database and the reports data warehouse must be the same and be case-insensitive, regardless of whether the product is installed in an English or a non-English locale.

Related topic

Creating databases and users on SQL Server