Art of BI: SQL Exception: The TCP/IP Connection to the host has failed. java.net.ConnectionException

Recently when configuring a JSP page based on Venkat’s walk-through of linking an HFR report to an OBIEE answers report we bumped into the following error when trying to access our SQL Server database. It turns out this error is caused when TCP/IP to the SQL Server server instance has been disabled. It is actually disabled by default. Below are the steps to resolve the issue. Once we’ve enabled TCP/IP our JSP page using the JDBC call worked like a charm.

Here is the error:
jdbc_error_in_page_cropped

Open your SQL Server Configuration Manager (Programs > Microsoft SQL Server 2005 > Configuration Tools > …)
ssms_config_mgr

In Configuration Manager, expose the Network Configurations
access_msss_configuration_manager

Right-Click on the TCP/IP item to select it and in the menu click on “Enable”
enable_configuration_mgr_tcpip

Refresh your page and all should be a go.

Contact Us
Christian Screen
Christian is an innovator in analytics and data warehousing design, best practices, and delivery. With more than fifteenyears of decision support and data warehousing with key experiences at Office Depot HQ, Sierra-Cedar, and Capgemini, he oversees the Oracle Analytics Practice which includes the technical development and delivery of Oracle BI collaboration software, data warehouse solutions, Oracle BI/EPM projects, and packaged analytics solutions at Datavail.

Comments are closed.