Setting Up a SQL Server Database

To set up SQL Server:

  1. Satisfy the requirements. See Requirements.

  2. In SQL Server, create an instance of the server in which to create the target database.

  3. Access the SQL Server instance.

  4. Navigate to %EPM_ORACLE_HOME%\products\hsf\cfg and run these scripts in order using Query Analyzer to create the export database:

    • Step1_create_HSF_database — Creates the Strategic Finance SQL Server database (hsfsvr)

    • Step1alt_remove_objects — Removes objects

    • Step2_security — Configures logins and permissions. By default, login = hsfdbuser and password = password

    • Step3_tables_grants — Contains the base Strategic Finance database schema including tables, and indexes

    • Step4_procs_funcs — Contains stored procedures and functions

  5. See Creating SQL Server Export Databases and thenConfiguring the External Database Connection.