Manish
Reputation: 23
Azure Function access to SQL Server -IAAS through managed identity
I have an Azure function and a user assigned managed identity. I would like to connect a SQL Server hosted on Azure VM.
But the problem is CREATE USER/CREATE LOGIN [mymangedIdentity] FROM EXTERNAL PROVIDER clause is not supported for Azure AD authentication on SQL Server hosted on Azure VMs. It only works in Azure SQL and Azure MI.
Upvotes: 0
Views: 204
Answers (1)
David Browne - Microsoft
Reputation: 89371
Entra ID (AAD) Auth for SQL Server is a SQL Server 2022 feature.
SQL Server 2022 (16.x) introduces support for authentication with Microsoft Entra ID (formerly Azure Active Directory), on both Windows and Linux on-premises, and SQL Server on Windows Azure VMs.
Microsoft Entra authentication for SQL Server
Upvotes: 0
Related Questions
- "The certificate chain was issued by an authority that is not trusted" when connecting DB in VM Role from Azure website
- How to concatenate text from multiple rows into a single text string in SQL Server
- How to add a column with a default value to an existing table in SQL Server?
- What is the best way to auto-generate INSERT statements for a SQL Server table?
- Check if table exists in SQL Server
- Reset identity seed after deleting records in SQL Server
- How do I UPDATE from a SELECT in SQL Server?
- How to check if a column exists in a SQL Server table
- LEFT JOIN vs. LEFT OUTER JOIN in SQL Server
- How can I delete using INNER JOIN with SQL Server?