I have a SQL database that is being used to store data pushed from D365 and needs to be accessed from AWS. The requirement is as follows: a. The access to the Azure SQL database should be using the internal network using private endpoints/links. b. The user/identity should authenticate using Azure AD credentials and not using the (native) SQL user. I tried this from my end but it results as follows: AD user authentication does not work if the SQL database url points to a Private IP address. AD user authentication works only if the SQL database url points to a Public IP address. The SQL database has not been added to a VNET enabling service endpoints as this might block the connections from D365 ? Can anyone explain what is the reason behind the behavior for the above 2 scenarios ? And is there a way to provide a solution that satisfies both the requirements (a and b) ?

Unable to authenticate with Azure AD credentails in Azure SQL Database using private endpoint/links

arunjohnv 1

I have a SQL database that is being used to store data pushed from D365 and needs to be accessed from AWS.

The requirement is as follows:
a. The access to the Azure SQL database should be using the internal network using private endpoints/links.
b. The user/identity should authenticate using Azure AD credentials and not using the (native) SQL user.

I tried this from my end but it results as follows:

AD user authentication does not work if the SQL database url points to a Private IP address.
AD user authentication works only if the SQL database url points to a Public IP address.

The SQL database has not been added to a VNET enabling service endpoints as this might block the connections from D365 ?

Can anyone explain what is the reason behind the behavior for the above 2 scenarios ?

And is there a way to provide a solution that satisfies both the requirements (a and b) ?

Oury Ba-MSFT 16,471 Reputation points Microsoft Employee

2021-05-25T17:30:50.03+00:00

Hello anonymous user We are looking into this and will get back. Thanks for your patience
Regards,
Oury
Oury Ba-MSFT 16,471 Reputation points Microsoft Employee

2021-05-27T22:58:42.683+00:00

Hello anonymous user My apology for the late reply. After checking this issue , We are unable to comment based on the information provided above. To better assist you , I will suggest to open a support request so we can better help you troubleshoot this issue. Please do share the ticket number so we can keep traction.
Regards
Oury
Oury Ba-MSFT 16,471 Reputation points Microsoft Employee

2021-06-01T15:55:38.83+00:00

Hello anonymous user Were you able to create a support request.? Please do share the ticket number so we can keep traction.
Regards
Oury