From what I found, the problem seems to be related to password protected tables in your database.
Here’s a possible solution.
Microsoft Visual Basic:
“Runtime error 20599 – Can’t Open SQL Server”
This issue occurs on all Active Data reports which have been created using the Active Data driver, P2smon.dll version 60046 or higher and the “Data Source” option chosen was either ADO, RDO or DAO. Reports which are created with the Data Definition file (TTX file), as the data source, do not encounter this issue.
There are two workarounds available as a solution. One is to create the report with a Data Definition file (TTX) and the other workaround is to use the Report Design Component’s (RDC) Automation Server
To create the report using a Data Definition File, see ‘Creating Field Definition Files’ in the developers help for more information on how this is done.
The next solution is to use the Report Design Component’s (RDC) Automation Server. This Automation Server does not use the Crpe32.dll, instead using it’s own print engine (Craxdrt.dll).