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.

Sodhi, Harkrishan 0 Reputation points
2024-05-29T06:41:24.1733333+00:00

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.

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
757 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaktiSingh-MSFT 14,281 Reputation points Microsoft Employee
    2024-05-29T12:08:13.1+00:00

    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://video2.skills-academy.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

    0 comments