Error: Communication Link Failure. Failed to Connect to Server

Issue

Setup tests fail during the Cluster Configuration test. The following error appears:

Communication link failure. Failed to connect to server. Reason: HTTP Response code: 403, Error message: PERMISSION_DENIED: OAuth_Client_ID is not authorized to use this SQL Endpoint. Please contact your administrator.

Environment

• Destination: Databricks
• Authentication method: OAuth machine-to-machine (M2M)

Resolution

To resolve this issue, ensure the following:

• The Workspace access and Databricks SQL access entitlements are enabled for the authorizing user. For more information, see Databricks' Manage entitlements documentation.
• The authorizing user is assigned to the applicable Databricks SQL workspace. For more information, see Databricks' Assign a service principal to a workspace documentation.

Cause

This issue occurs when the authorizing user doesn't have the permissions required to access the server.