Select Page

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

Author: Christian Screen | | July 7, 2009

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.

Oracle BI Publisher (BIP) Tips: Functions, Calculations & More

Check out these BI Publisher tips including functions & calculations so you can understand more about the production and support of BI Publisher reports.

Sherry Milad | January 15, 2018

Qlik vs. Tableau vs. Power BI: Which BI Tool Is Right for You?

Tableau, Power BI, and Qlik each have their benefits. What are they and how do you choose? Read this blog post for a quick analysis.

Tom Hoblitzell | June 6, 2019

How to Index a Fact Table – A Best Practice

At the base of any good BI project is a solid data warehouse or data mart.

Christian Screen | March 16, 2010

Subscribe to Our Blog

Never miss a post! Stay up to date with the latest database, application and analytics tips and news. Delivered in a handy bi-weekly update straight to your inbox. You can unsubscribe at any time.

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.

CONTACT US

Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.

EXPLORE JOBS