I have connected my Azure SQL id with on premisis with Authentication Microsoft Entra indentity, while creating database scoped credential i am not able to get what identity and secret need to enter.i tried my local but not able to query external table.

Question

I have connected my Azure SQL id with on premisis with Authentication Microsoft Entra indentity. while creating database scoped credential i am not able to get what identity and secret need to enter.i tried my local but not able to query external table.Please help me out what wrong thing i am doing.

Answer 1

Hi Sodhi, Harkrishan •,

Welcome to Microsoft Q&A forum.

As I understand, you are trying to create Database Scoped Credential for Azure SQL Database with Entra Authentication.

Please use syntax as below:

CREATE DATABASE SCOPED CREDENTIAL credential_name

WITH IDENTITY = 'identity_name'

[ , SECRET = 'secret' ]

Note:

The only PolyBase external data source that supports Kerberos authentication is Hadoop.

All other external data sources (SQL Server, Oracle, Teradata, MongoDB, generic ODBC) only support Basic Authentication.

Reference: https://learn.microsoft.com/en-us/sql/t-sql/statements/create-database-scoped-credential-transact-sql?view=sql-server-2017

Let us know more on the query if above does not help so that we can assist.

Thanks