Select Page

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

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:

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

In Configuration Manager, expose the Network Configurations

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

Refresh your page and all should be a go.

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.

12c Upgrade Bug with SQL Tuning Advisor

This blog post outlines steps to take on Oracle upgrade 11.2 to 12.1 if you’re having performance problems. Oracle offers a patch and work around to BUG 20540751.

Megan Elphingstone | March 22, 2017

Oracle EPM Cloud Vs. On-Premises: What’s the Difference?

EPM applications help measure the business performance. This post will help you choose the best EPM solutions for your organization’s needs and objectives.

Bobby Ellis | April 10, 2018

Scripting Out the Logins, Server Role Assignments, and Server Permissions

Imagine over one hundred logins in the source server, you need to migrate them to the destination server. Wouldn’t it be awesome if we could automate the process?

JP Chen | October 1, 2015

Work with Us

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


Work for Us

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