In the second section of Part 1 I’d like to show you how to set up the SQL Server for Hyperion System 9.3.1. I would like to stress that this is not the only way to configure SQL for Hyperion, this is just my way for a stand alone system. Maybe I might be doing a few extra steps that need be here but it eliminates other likely issues further ahead.
Before we start I feel compelled to let you know that it is more efficient to setup multiple user accounts and databases for the applications. You could for example create a ‘hss’ database with ‘hssuser’ for Shared Services and ‘plan’ with user ‘planuser’ for the Hyperion Planning application. On a live system that would be ideal but creating a ‘hypdb’ database with ‘hypuser’ on a standalone server works just as good.
So without further ado, please find the SQL Server setup instructions below:

How to Install Hyperion Planning / Workspace / Essbase Part 1b – SQL Server Setup for Hyperion Planning