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

Deepak Rane (drane) 60

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.

Oury Ba-MSFT 19,501 Reputation points Microsoft Employee

2024-07-01T16:57:23.6733333+00:00

Deepak Rane (drane)

I wanted to check if the above comment was helpful. Please do let us know if you need more clarification.

Regards,

Oury
Deepak Rane (drane) 60 Reputation points

2024-07-03T16:06:21.6366667+00:00

Yes That's useful but the thing now is I am connecting with "Microsoft Entra service principals" Authentication with my C# application.

And the TSQL by which we create Symmetric Key on below links I need to use

"[ AUTHORIZATION owner_name ]" ,

where its not working with the APP ID used for owner name by which we are logged in to server.
What can be used when this authentication used an logged with appid and secret
Deepak Rane (drane) 60 Reputation points

2024-07-03T16:12:34.51+00:00

Thanks for the response @Oury Ba-MSFT . Its helpful.

Now the another challenge is we are using "Microsoft Entra Service Principal" while connecting from C#.
And the TSQL for symmetric key contains "[ AUTHORIZATION owner_name ]"
for Owner_name we use appid which we used to login from Microsoft Entra Service Principal
But is not working.
Deepak Rane (drane) 60 Reputation points

2024-07-08T11:48:10.21+00:00

@Oury Ba-MSFT

Did you got a chance to check on this part please?
Oury Ba-MSFT 19,501 Reputation points Microsoft Employee

2024-08-13T15:52:10.1633333+00:00

@Deepak Rane (drane)Sorry for missing the above question.

Are you getting an error message? Can you please share the syntax you have used?

Regards,

Oury

1 answer

Oury Ba-MSFT 19,501 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
Please sign in to rate this answer.
Oury Ba-MSFT 19,501 Reputation points Microsoft Employee

2024-07-16T20:02:53.8866667+00:00

@Deepak Rane (drane) Please don't forget to mark as accept answer if the reply was helpful.

Regards,

Oury
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

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

1 answer

Your answer