Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
8,930 questions
Connect to SQL Instance hosted on Azure VM using Windows Auth from Azure App Service
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 12%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAF%3C/text%3E%3C/svg%3E)
Alex Feakes
0
Reputation points
The Azure app is hosting a .NET Core app. It can connect to the SQL instance using a SQL login and FQDN. I can't connect using Integrated (i.e. Windows) Authentication. Error is Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication.
Azure App Service
{count} votes
-
VenkateshDodda-MSFT 24,951 Reputation points Microsoft Employee Moderator2023-11-09T12:43:42.9333333+00:00 @Alex Feakes Thanks for reaching out to Microsoft Q&A, apologize for any inconvenience caused on this.
Connecting to SQL instance through App service using Windows Integrated Authentication is not possible.
Also, you can connect to SQL database using any of the below methods or you can use the same using SQL login.
- Using Managed Identity
- Azure AD authentication on behalf of signed-in user.
- Using database connection string as connection string to App service
Feel free to reach back to me if you have any further questions on this.
-
Alex Feakes 0 Reputation points
2023-11-09T13:44:01.5266667+00:00 @VenkateshDodda-MSFT thanks for you response on this. Is there any way to connect to a SQL instance hosted in a VM other than with a SQL Login (your option 3)? It seems options 1 & 2 only work for Azure SQL Database (i.e. SAAS).
Thanks in advance.
Alex
-
VenkateshDodda-MSFT 24,951 Reputation points Microsoft Employee Moderator
2023-11-14T10:51:21.56+00:00 @Alex Feakes Thanks for your response and follow-up questions. Apologize for the delay in my response.
You can also connect the sql server instance vm from app service using vnet integration or through hybrid connections as mentioned in this similar SO thread.
-
VenkateshDodda-MSFT 24,951 Reputation points Microsoft Employee Moderator
2023-11-17T04:09:25.4466667+00:00 Hello @Alex Feakes ,
Following up to see if you have a chance to check my previous response and helped. Do let us know if you have any further questions on this.
Sign in to comment
Sign in to answer