SAP Knowledge Base Article - Public

1585069 - Facing error "TCP Provider: No Connection could be made because the target machine actively refused it. DA0004" for Desktop Intelligence reports in infoview

Symptom

Facing error "TCP Provider: No Connection could be made because the target machine actively refused it. State: 08001 A connection required to refresh this document is unavailable. (DA0004)" for Desktop Intelligence reports in infoview with free hand sql data providers in infoview.

Environment

BusinessObjects version: XI 3.x

Database: MS SQL SERVER 2005

Middleware : ODBC DRIVERS

Reproducing the Issue

  • Desktop Intelligence reports not working based on odbc connection in infoview.
  • Facing error "TCP Provider: No Connection could be made because the target machine actively refused it. State: 08001]A connection required to refresh this document is unavailable. (DA0004)".
  • Reports are using odbc drivers with free hand sql dataproviders.
  • Working in client machine.
  • Go to the server machine remotely.
  • Now, launch the Desktop Intelligence application, test the connection for the particular free hand sql dataprovider and observe the same error.

Cause

DSN may not be configured properly

Resolution

  1. Logon to BusinessObjects server machine remotely.
  2. Go to Data sources under Control panel>>Administrative tools
  3. In the System DSN, test the connection and observe the same error.
  4. Change the server name in DSN, to servername\instance name.
  5. Now, test is successful.

Keywords

DA0004, TCP Provider: No Connection could be made, the target machine actively refused it. State: 08001, SQL SERVER, ODBC DRIVERS, Desktop Intelligence, deski , infoview , KBA , BI-RA-DKI , Desktop Intelligence , Problem

Product

SAP BusinessObjects Dashboards 4.5