Microsoft SQL Server Database Creation Requirements

Important Notice:

  • Oracle Hyperion Financial Management (HFM) is not supported on SQL Server instances where the master database was created using a binary collation (BIN or BIN2), such as SQL_Latin1_General_CP850_BIN2.

  • Binary instance collations prompt SQL Server to emit informational messages (For example, SET LANGUAGE, USE <database>), which subsequently cause Financial Management (HFM) applications to fail in establishing connections.

When creating a Microsoft SQL Server database for use as a repository, ensure that you set these options:

  • ALTER DATABASE DATABASE_NAME COLLATE SQL_Latin1_General_CP1_CI_AS

  • Set READ_COMMITTED_SNAPSHOT = ON (Financial Management requires READ_COMMITTED_SNAPSHOT = OFF).

  • Set ALLOW_SNAPSHOT_ISOLATION = ON (Financial Management requires ALLOW_SNAPSHOT_ISOLATION = OFF).

  • Select the SQL Server and Windows authentication option when you set the security properties for the database.

Oracle recommends that you add a prefix to the user name that will correspond to the RCU schema prefix used during configuration.

You must also create a database to be used with the Repository Creation Utility (RCU).

For the RCU database, run these queries:

• ALTER DATABASE DATABASE_NAME SET READ_COMMITTED_SNAPSHOT ON

• ALTER DATABASE DATABASE_NAME COLLATE LATIN1_GENERAL_CS_AS