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