Linked Server Error

  • 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.

  • 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