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
Cause
DSN may not be configured properly
Resolution
-
Logon to BusinessObjects server machine remotely.
-
Go to Data sources under Control panel>>Administrative tools
-
In the System DSN, test the connection and observe the same error.
-
Change the server name in DSN, to servername\instance name.
-
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 , Obsolete - Desktop Intelligence , Problem