0
votes

is it possible to connect to Azure SQL Database by using Managed Service Identity? I'd like to rip out SQL credentials.

Thank you for your advises!

Best

2
From what? That's what makes the difference. From C# or powershell code? Most likely. From SSIS or SSAS? NoNick.McDermaid
From PowerShellsflach
And is the powershell executed in Azure automation?Nick.McDermaid
To save back and forth please post MVC stackoverflow.com/help/mcveNick.McDermaid

2 Answers

1
votes

Yes, it is possible. See this article for reference.

0
votes

If you want to use a Managed Service Identity in Azure function you can have a look at this article:

How to use Azure Managed Service Identity (public preview) in App Service and Azure Functions

To authenticate to SQL with a Managed Service Identity you can have look at this article:

Azure SQL authentication with a Managed Service Identity

It should be enough to achieve what you need.