ORA-12638: Credential retrieval failed

[Cam]

I'm having difficulty running reports against our Oracle 9i database. I have
successfully setup the Oracle client on the reporting server (windows 2003
server, iis, sql server 2000) and I'm able to write and preview reports
against data in the Oracle DB (using the Microsoft OLE DB provider for
Oracle) with the Visual Studio report designer. However, when I attempt to
execute any of these reports from the Report Manager web interface I receive
the following error message.

An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'Visual_Oracle'.
(rsErrorOpeningConnection)
ORA-12638: Credential retrieval failed

I've already tried to save the credentials in the Report Server for this
datasource and I've also tried to give read and execute permissions to the
NETWORK SERVICE account for the "Oracle/Oracle version/bin" and
"Oracle/Oracle version/network/admin" directories but this hasn't solved the
problem.

Just wondering if anyone can point me to a KB article or offer a solution to
my this problem.

Thanks for your help.
Cam

[Cam]

Looks like I've found a workaround to this issue by changing Oracle's default
authentication protocol. I simply edited the SQLNET.ORA file found in the
Oracle/Oracle version/network/admin directory from...

SQLNET.AUTHENTICATION_SERVICES = (NTS)

to

SQLNET.AUTHENTICATION_SERVICES = (NONE)


Now everything my reports seem to be working.

Thanks again
Cam

Post by Cam
I'm having difficulty running reports against our Oracle 9i database. I have
successfully setup the Oracle client on the reporting server (windows 2003
server, iis, sql server 2000) and I'm able to write and preview reports
against data in the Oracle DB (using the Microsoft OLE DB provider for
Oracle) with the Visual Studio report designer. However, when I attempt to
execute any of these reports from the Report Manager web interface I receive
the following error message.
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'Visual_Oracle'.
(rsErrorOpeningConnection)
ORA-12638: Credential retrieval failed
I've already tried to save the credentials in the Report Server for this
datasource and I've also tried to give read and execute permissions to the
NETWORK SERVICE account for the "Oracle/Oracle version/bin" and
"Oracle/Oracle version/network/admin" directories but this hasn't solved the
problem.
Just wondering if anyone can point me to a KB article or offer a solution to
my this problem.
Thanks for your help.
Cam

[z***@gmail.com]

While everything is working, I thought I will add my observation here.
ORA-12638 applies very specifically to Windows Servers and occurs if
you are attempting to connect to the server from a different domain
controller. If the domain controllers are the same, then you will not
get this error if SQLNET.AUTHENTICATION_SERVICES is left at (NTS) which
is the default parameter.

Regards,
z1hou1