Unable to connect the sql server using windows authentication from asp.net application

Question

Unable to connect the sql server using windows authentication from asp.net application

Thyagarajulu B M 121

Hi Team,

Please find the details below.

Current Infrastructure Setup:

AzurewebappVM
AzureDBVM
Created new Windows domain account (ABC\Test) in the on-premises Active directory.
Merged on-premises activity directory and Azure Active Directory with the help of Azure AD Connect

Database Access:

We have added the ABC\Test Windows account to the SQL server on Azure VM and provided the required databases access.

Issue:

When we are trying to connect the SQL server on an Azure VM using Windows authentication from asp.net application in the Azure Web app, we are getting an error.

Kindly help us on this issue. Are we taking the right approach to connecting the SQL server?

Thomas Meads 1,586 Reputation points

2023-09-06T17:02:41.9966667+00:00

What is the error you're getting?
Olaf Helper 47,436 Reputation points

2023-09-07T10:14:16.9433333+00:00

Please post the complete error message; we can't guess it.

How does your connection string look like?
ajkuma 28,036 Reputation points Microsoft Employee Moderator

2023-09-08T16:08:28.4733333+00:00

Thyagarajulu B M, Just checking in to see if you had got a chance to see the previous response by Ben Gimblett. If the answer helped (pointed, you in the right direction) > please click Accept Answer
Or please share the requested/more info to help you better.

1 answer

Your answer

Thomas Meads 1,586 Reputation points

2023-09-06T17:02:41.9966667+00:00

What is the error you're getting?
Olaf Helper 47,436 Reputation points

2023-09-07T10:14:16.9433333+00:00

Please post the complete error message; we can't guess it.

How does your connection string look like?
ajkuma 28,036 Reputation points Microsoft Employee Moderator

2023-09-08T16:08:28.4733333+00:00

Thyagarajulu B M, Just checking in to see if you had got a chance to see the previous response by Ben Gimblett. If the answer helped (pointed, you in the right direction) > please click Accept Answer
Or please share the requested/more info to help you better.

Answer 1

Ben Gimblett 4,560 Microsoft Employee

Hi thanks for the question
Az App Service does not support Windows Authentication (it's the same for most PaaS services)

You do have the option of using AAD Auth here as per https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/configure-azure-ad-authentication-for-sql-vm?view=azuresql&tabs=azure-portal
App service supports managed identities - so if it's App to app you need then using a user-assigned or system-assigned MSI toward SQL on the VM would be preferable

Ben Gimblett 4,560 Reputation points Microsoft Employee

2023-09-07T10:40:15.47+00:00

later dot net sql drivers encapsulate acquiring and sending a token for the MSI (so you dont need to worry about it) https://learn.microsoft.com/en-us/sql/connect/ado-net/sql/azure-active-directory-authentication?view=sql-server-ver16#using-active-directory-managed-identity-authentication

Before that, in past versions, you would need to use the DefaultAzureCredential (microsoft.identity) and pass that to the connection with the connection string

Share via

Unable to connect the sql server using windows authentication from asp.net application

1 answer

Your answer