Unable to Start EPMA Process Manager Service When Using SQL Server Named Instance or Non Standard Port (Doc ID 1162697.1)

Last updated on AUGUST 01, 2016

Applies to:

Hyperion Financial Management - Version 11.1.1.3.00 and later
Microsoft Windows x64 (64-bit)

Symptoms

When trying to start Enterprise Performance Management Architect (EPMA) Process Manager Windows Service, the service fails to start and the following error message is displayed:

The Hyperion Epm Architect Process Manager service on Local Computer started and then stopped.  Some services stop automatically if they have no work to do, for example the Performance Logs and Alerts service.

In the Windows Event Viewer the detail of the message from the Process Manager service contains the following information:

Service cannot be started. Cannot initialize the session manager. Database connectivity could not be established
System. A network related or instance-specified error occurred while establishing a connection to SQL server. The server was not accessible. Verify the instance name is correct and SQL server is configured to allow remote connection.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms