The problem I’m having
We are about to sign an Enterprise license, but currently trying to connect dbt Developer to our Fabric Warehouse. We are getting an error message saying " 1 check failed:
dbt was unable to connect to the specified database.
The database returned the following error:
Database Error
(‘28000’, ‘[28000] [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Could not login because the authentication failed. (18456) (SQLDriverConnect)’)
Check your database credentials and try again. For more information, visit:
Connection profiles | dbt Developer Hub"
The context of why I’m trying to do this
We are using a Service Principal and Tenant, Client ID and Client Secret to authenticate from the dbt Cloud screen. We have copied our Warehouse Connection string into the Server, used port 1433 and the database is the name of our Warehouse. Our Service Principal has contribute access on the Fabric Workspace that the Warehouse resides in. We have also tried giving the Service Principal Admin access on the Fabric Workspace that the Warehouse resides in.
Questions : 1) What account is dbt trying to reach into the Fabric Warehouse with, is it the Service Principal?
2) What Permissions does that account need and where should they be set, Workspace or Warehouse or both (not sure you can set on the Warehouse)?
Any help/advice much appreciated. We have a call open with Microsoft, but as not yet a dbt paying customer cannot raise a ticket for assistance.
We can see in the Entra ID Azure logs the Service Principal successfully connecting to an Azure SQL Database - but can’t see where it is failing - i.e. the error dbt is reporting.