Hi,
I had a perfectly working Hyperion Planning Plus environment on my laptop. It was on 11.1.2.3 with SQL Server 2008 R2 as backend along with ESSBASE. Things were working fine.
I swapped my laptop to a newer laptop and started building the environment again. This time I wanted to build with newer version i.e 11.1.2.4 on SQL Server 2008 R2. And I have used newer version of VirtualBox 5.0 for the virtualisation.
The installation and configuration went smoothly. I navigated to Planning Administration --> Manage Data Sources and filled in the "Application Database". When I hit validate, it started telling me "The database connection failed". I googled and found this helpful post error establishing socket to host and port: EPM11:1433. I enabled the TCP/IP protocol, restarted the SQL Server services and to my surprise, it was showing the same message again. Tried with IP address instead of hostname, no luck. It seems someone else also faced similar issue even after enabling the TCP/IP protocol but no further replies to it.
I checked the logs and found the following
2015-07-28T22:37:56.357+01:00] [EPMServer0] [NOTIFICATION] [HSP-0000000002] [oracle.EPMHSP.planning] [tid: 38] [userId: <anonymous>] [ecid: 0000KvMaNNzFCCWFLzJN8A1LhvGO0000Ea,0] [APP: PLANNING#11.1.2.0] [SRC_CLASS: com.hyperion.planning.HspUpgradeWizardHelper] [SRC_METHOD: testDBConnectivity] An error occurred while testing database connection[[
java.sql.SQLNonTransientConnectionException: [FMWGEN][SQLServer JDBC Driver]Error establishing socket to host and port: HYPLAN:1433. Reason: Connection refused: connect
at weblogic.jdbc.sqlserverbase.ddb_.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb_.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.b(Unknown Source)
blah blah blah
blah blah blah
blah blah blah
blah blah blah
I was little frustrated for being stuck. Spent around an hour and half and found the following solution (source https://www.monkehworks.com/local-sql-server-2008-coldfusion-datasource/ ) . It was purely my oversight and lost time for no reason. I thought of updating the same post but the post is archived. So creating this new post. Moderator may decide to take this content and amend the thread 2265799 and close this one.
In addition to the steps listed by John in the above post, if you still face issues, navigate to IP Addresses Tab (next to Protocol tab) and ensure its enabled explicitly, and the TCP Dynamic Ports is blank and TCP Port is 1433. I repeated the same for IP2, IP3, IPn, IPAll. See the attached screenshots for more information.
[
](/servlet/JiveServlet/showImage/38-6409-133525/socket issue.PNG)
[
](/servlet/JiveServlet/showImage/38-6409-133547/socket issue2.PNG)
Cheers,
K