Skip to content
Advertisement

Trying to connect Polybase to Oracle leads to Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication

I’m using SQL Server 2019 and try to connect to a Oracle DB via Polybase:

CREATE DATABASE SCOPED CREDENTIAL OracleUser WITH IDENTITY = 'username', Secret = 'password';

CREATE EXTERNAL DATA SOURCE [OrDB] WITH (LOCATION = N'oracle://192.168.1.5:1521'), 
CREDENTIAL = OracleUser);

I’m getting the error:

Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication.

However the user is not a domain user and oracle does not use integrated authentication.

Advertisement

Answer

As I mentioned in my comment above, you get this error if you are logged into your SQL Server instance with integrated security. This is due to a regression bug in SQL Server 2019.

Log in with SQL authentication instead, and it will work.

User contributions licensed under: CC BY-SA
4 People found this is helpful
Advertisement