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.

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.