SQL Server Linked Server query to Oracle will not work when rdp onto the sql server but will work when connecting from laptop

Question

We have an offsite server A hosting an Oracle database, and an on-site SQL Server B.

We have a linked server set up on B pointing at A.

If I connect from my laptop to SQL Server B and run a query against the linked server, the query will succeed.

If I remote desktop onto SQL Server B and run the same query I get the following error:

RA-12638: Credential retrieval failed

The query works from every machine I have tried it on apart from Server B where the SQL Server is hosted, what might be causing this issue?

how is the linked server configured? e.g. how is it configured to authenticate with the oracle database? — ADyson
– ADyson, Commented Dec 16, 2020 at 9:21
provider: oracle provider for oledb; data source: ip address:port\service name; security: remote login and password specified; server options: all default — James Lester
– James Lester, Commented Dec 17, 2020 at 10:37
Possibly dba-oracle.com/t_ora_12638_credential_retrieval_failed.htm would help you? — ADyson
– ADyson, Commented Dec 17, 2020 at 10:55
thanks I'll take a look, its also worth pointing out we have the same issue when we try and test a connect using oracle net manager which is also installed on the sql server B — James Lester
– James Lester, Commented Dec 17, 2020 at 14:07

James Lester · Accepted Answer · 2020-12-18 11:13:49Z

2

This was resolved by updating sqlnet.ora, changing authentication from NTS to NONE.

answered Dec 18, 2020 at 11:13

James Lester

459 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

and it needed a sql service restart to take effect on the linked server