I am receiving this error -
An error has occurred during report processing. (rsProcessingAborted) Get Online Help Cannot create a connection to data source 'IFSDB'. (rsErrorOpeningConnection) Get Online Help ORA-12638: Credential retrieval failedWhen I attempt to run a report that accesses an Oracle database. If I sign on to the report server and run the report, it is successful. When I attempt to run it from any other workstation, I get the above error.
We are running both Oracle and SQL Server on the same server.
Particulars -
SQL Server 2000,
Oracle 9.2.0.6
Windows Server 2003
Thanks for any and all help
First, I suggest to check your Oracle client configuration file (ORA_HOME\network\admin\sqlnet.ora) and consult the Oracle documentation. Most likely you can resolve the error by changing the configuration file line
SQLNET.AUTHENTICATION_SERVICES= (NTS)
into:
SQLNET.AUTHENTICATION_SERVICES=(NONE)
If you then run into other Oracle error messages, it may be causes by insufficient file system permissions to read certain files of the Oracle client installation. See this KB article for details: http://support.microsoft.com/?kbid=870668
-- Robert
No comments:
Post a Comment