CODEWITHSUNDEEP
azureazure-data-factoryerror-logsql-data-warehouse
Molotch
Molotch

Reputation: 475

Debug sql database scoped credentials failure

I created a scoped credential in a Azure SQL Datawarehouse database to create an external table over some files in a Azure Data Lake Store.

When I try creating the external table I get the message.

Msg 105061, Level 16, State 1, Line 35 Unable to find any valid credential associated with the specified data source. Credential is required to connect to Azure Data Lake Store.

How do I troubleshoot this? My AzureAD application has access to the storage. I use the same AD-application (with a different key) for my Azure Data Factory pipeline that stores the files in the Azure Data Lake Store.

I haven't found any commands that let you test your credentials and see what credentials the database tries to use or why it fails. Any ideas?

https://learn.microsoft.com/en-us/sql/t-sql/statements/create-database-scoped-credential-transact-sql

Upvotes: 1

Views: 853

Answers (1)

Molotch
Molotch

Reputation: 475

So I had missed adding my scoped credential when I created the external data source. So create the scoped credential first, then the external data source.

Upvotes: 1

Related Questions