topic Re: Error: Node.js SQL Driver auth using M2M in Administration & Architecture

Error: Node.js SQL Driver auth using M2M

ossinova — Mon, 18 Mar 2024 09:38:54 GMT

I am trying to follow the documentation in order to establish a M2M authentication through the Node.js SQL Driver. I am however having issues as it results in the following error message. What is it that I am not seeing here?

Error msg:

{"level":"info","message":"Created DBSQLClient"}
{"level":"info","message":"DBSQLClient: initializing thrift client"}
OPError: invalid_request (AADSTS50059: No tenant-identifying information found in either the request or implied by any provided credentials. Trace ID: 5545d0f4-6f9e-4de4-bf3b-10dcda1c0e00 Correlation ID: b70cbffc-d079-448f-bc8c-70d39ef882c5 Timestamp: 2024-03-18 09:21:41Z)

Re: Error: Node.js SQL Driver auth using M2M

ossinova — Mon, 18 Mar 2024 09:51:39 GMT

The same credentials work fine using the CLI (M2M)

Re: Error: Node.js SQL Driver auth using M2M

ta2 — Wed, 03 Apr 2024 17:17:22 GMT

Not sure if you're still suck on this but I had the same issue and managed to resolve it by adding

azureTenantId: <my-tenant-id> and useDatabricksOAuthInAzure: true in the client connection options. Hope this helps!