Creating Certifcate Or Symmetric key Over Azure Managed Instance with Entra Service principal

Deepak Rane (drane) 60 Reputation points
2024-06-28T14:13:48.8733333+00:00

Hi Team,

We are connecting a database over Azure SQL Managed Instance from our C# application.

We need to create Symmetric-Key/Asymmetric-Key/Certificate with TSQL statement.

Azure SQL Database
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
20,468 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Oury Ba-MSFT 17,786 Reputation points Microsoft Employee
    2024-06-28T16:12:05.6933333+00:00

    @Deepak Rane (drane) Thank you for reaching out.

    Assuming that you are already connected to your Azure SQL DB managed Instance through C#. Now, you are trying to create Symmetric-Key/Asymmetric-Key/Certificate with TSQL statement.

    Once the connection is established, you can create Symmetric-Key/Asymmetric-Key/Certificate using TSQL statements.

    You can go through the below docs to create an asymmetric key and a certificate.

    CREATE SYMMETRIC KEY (Transact-SQL)

    CREATE CERTIFICATE (Transact-SQL)

    If you need further assistance, feel free to ask!

    Regards,

    Oury

    0 comments No comments