Technologies
- Popular Resources
  
  White Paper
  
  .NET Workflow Solutions for SharePoint
  
  Workflows are available within Microsoft SharePoint, and help users track and monitor documents or files associated with a specific business process.
  
  White Paper
  
  10 Reasons You Need Half a DBA
  
  Nearly all companies need database administrators– but not all companies need a full time DBA. Sometimes you might need “half a DBA.” Sometimes it’s for a one-time need, such as during a transition to a new platform or a surge in overflow work.
  
  Service Overview
  
  360-degree Hyperion Support Overview
  
  Every organization has unique needs, which is why we offer 360-degree Hyperion support tailored to what will help your organization to improve the most.
  
  Webinars
  
  5 Reasons to Choose a Managed Services Approach to Database Administration
  
  Datavail commissioned Forrester Consulting to evaluate the viability of a managed service approach to database administration. With the explosion in the variety, velocity and volume of data and databases, coupled with the scarcity of DBA talent, the time is right to consider an alternative approach to managing databases. Forrester Consulting conducted the survey of executives in mid to large enterprises who are using managed services to augment their in-house DBA.
- CLOSE MENU

Resources
- Popular Resources
  
  White Paper
  
  .NET Workflow Solutions for SharePoint
  
  Workflows are available within Microsoft SharePoint, and help users track and monitor documents or files associated with a specific business process.
  
  White Paper
  
  10 Reasons You Need Half a DBA
  
  Nearly all companies need database administrators– but not all companies need a full time DBA. Sometimes you might need “half a DBA.” Sometimes it’s for a one-time need, such as during a transition to a new platform or a surge in overflow work.
  
  Service Overview
  
  360-degree Hyperion Support Overview
  
  Every organization has unique needs, which is why we offer 360-degree Hyperion support tailored to what will help your organization to improve the most.
  
  Webinars
  
  5 Reasons to Choose a Managed Services Approach to Database Administration
  
  Datavail commissioned Forrester Consulting to evaluate the viability of a managed service approach to database administration. With the explosion in the variety, velocity and volume of data and databases, coupled with the scarcity of DBA talent, the time is right to consider an alternative approach to managing databases. Forrester Consulting conducted the survey of executives in mid to large enterprises who are using managed services to augment their in-house DBA.
- CLOSE MENU

Blog
- Popular Resources
  
  White Paper
  
  .NET Workflow Solutions for SharePoint
  
  Workflows are available within Microsoft SharePoint, and help users track and monitor documents or files associated with a specific business process.
  
  White Paper
  
  10 Reasons You Need Half a DBA
  
  Nearly all companies need database administrators– but not all companies need a full time DBA. Sometimes you might need “half a DBA.” Sometimes it’s for a one-time need, such as during a transition to a new platform or a surge in overflow work.
  
  Service Overview
  
  360-degree Hyperion Support Overview
  
  Every organization has unique needs, which is why we offer 360-degree Hyperion support tailored to what will help your organization to improve the most.
  
  Webinars
  
  5 Reasons to Choose a Managed Services Approach to Database Administration
  
  Datavail commissioned Forrester Consulting to evaluate the viability of a managed service approach to database administration. With the explosion in the variety, velocity and volume of data and databases, coupled with the scarcity of DBA talent, the time is right to consider an alternative approach to managing databases. Forrester Consulting conducted the survey of executives in mid to large enterprises who are using managed services to augment their in-house DBA.
- CLOSE MENU

About Us
- Popular Resources
  
  White Paper
  
  .NET Workflow Solutions for SharePoint
  
  Workflows are available within Microsoft SharePoint, and help users track and monitor documents or files associated with a specific business process.
  
  White Paper
  
  10 Reasons You Need Half a DBA
  
  Nearly all companies need database administrators– but not all companies need a full time DBA. Sometimes you might need “half a DBA.” Sometimes it’s for a one-time need, such as during a transition to a new platform or a surge in overflow work.
  
  Service Overview
  
  360-degree Hyperion Support Overview
  
  Every organization has unique needs, which is why we offer 360-degree Hyperion support tailored to what will help your organization to improve the most.
  
  Webinars
  
  5 Reasons to Choose a Managed Services Approach to Database Administration
  
  Datavail commissioned Forrester Consulting to evaluate the viability of a managed service approach to database administration. With the explosion in the variety, velocity and volume of data and databases, coupled with the scarcity of DBA talent, the time is right to consider an alternative approach to managing databases. Forrester Consulting conducted the survey of executives in mid to large enterprises who are using managed services to augment their in-house DBA.
- CLOSE MENU

Select Page

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

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.

Blog Author

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.

Popular Posts

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

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

Imagine there are over one hundred logins in the source server and you need to migrate them all over to the destination server. Wouldn’t it be awesome if we could automate the process by generating the scripts for the required tasks?

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.