How to access Azure SQL Database via MSI in PowerShell

Question

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

From what? That's what makes the difference. From C# or powershell code? Most likely. From SSIS or SSAS? No — Nick.Mc
– Nick.Mc, Commented Aug 22, 2018 at 23:56
To save back and forth please post MVC stackoverflow.com/help/mcve — Nick.Mc
– Nick.Mc, Commented Aug 24, 2018 at 8:56

hokkaidi · Accepted Answer · 2018-02-12 18:00:01Z

1

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

answered Feb 12, 2018 at 18:00

hokkaidi

9106 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Thomas · Accepted Answer · 2018-02-13 03:11:44Z

0

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

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

It should be enough to achieve what you need.

answered Feb 13, 2018 at 3:11

Thomas

30.5k6 gold badges99 silver badges143 bronze badges