Creating the RCU Schema for a Non - System Admin User

Use this procedure to create the RCU schema if you are a non System Admin user on SQL Server.

1. Create two databases one each for RCU and EPM (for example, TESTRCU and TESTEPM).
   • 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

   • For the EPM database, run this query:

     ALTER DATABASE DATABASE_NAME COLLATE SQL_Latin1_General_CP1_CI_AS

2. To create a Login User:
   1. Open Object Explorer in the SQL Server Management Studio.
   2. Click Security > Logins.
   3. On the General page, in the Login name field, type the name of the user (for example, EPMLogin.
   4. Select SQL server authentication. Type the password and re-enter to confirm. Deselect (uncheck) Enforce password policy. By default, this option is selected (checked).
   5. On the Server Roles page, assign the sysadmin role to the new login (for example EPMLogin). By default, the public role is assigned to the new login.
   6. On the User Mapping page, click on the two database names that you created (for example, TESTEPM and TESTRCU).
   7. Click Ok.

Updating RCU Database Connection details

Update the RCU database connection details using this as an example:

Database type - Microsoft SQL Server
Unicode Support - Select yes or No from the drop-down list
Server Name - Enter the host name, IP address, or complete server name in host\server format of the server where your database is running..
Port - Enter the port number for your database
Database Name - TESTRCU 
Username - EPMLogin
Password - Enter the password for your database user.

Updating RCU Schema properties

To update the RCUSchema.properties file for SQL Server, see Updating RCU Schema Properties