Microsoft SQL Server Database Creation Requirements

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 (not required for Oracle Hyperion Financial Management).

  • Set ALLOW_SNAPSHOT_ISOLATION = ON (not required for Financial Management).

  • 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