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.
BusinessObjects version: XI 3.x
Database: MS SQL SERVER 2005
Middleware : ODBC DRIVERS
Reproducing the Issue
DSN may not be configured properly
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.
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