December 10, 2014 at 1:19 pm
After configuring a SQL Server linked server using Oracle Oledb provider, I am unable to run queries using the linked server. I get the following error when I do:
"OLE DB provider "OraOLEDB.Oracle" for linked server "ORACLEBASIS2" returned message "ORA-12638: Credential retrieval failed""
Has anyone encountered this error?
thanks.
December 10, 2014 at 2:15 pm
Additional Information:
When I am logged into the SQL Server instance with Windows authentication I am able to retrieve data when I run my query. However, when I am logged into the instance with SQL Server authentication, I am unable to retreive data. I get the error:
"OLE DB provider "OraOLEDB.Oracle" for linked server "ORACLEBASIS2" returned message "ORA-12638: Credential retrieval failed""
Any help will be appreciated.
Thanks.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply